SELECT DISTINCT City FROM Customers;
SELECT * FROM Customers ORDER BY CustomerName DESC;
SELECT CustomerName AS 회원이름 FROM Customers;
SELECT CustomerID 회원번호, City 도시 FROM Customers;
연결 연산자 (Oracle : ||
, MsSQL : +
, MySQL : 공백
)
SELECT 1+1;
SELECT CustomerID+100 FROM Customers;
SELECT CustomerID % 2 FROM Customers;
SELECT Price 기존가, Price * 0.2 할인가, Price * 0.8 최종가 FROM Products;
||
col2SELECT Country || City || Address || PostalCode FROM Customers;
SELECT Country || ' ' || City || ' ' || Address || ' ' || PostalCode FROM Customers;
SELECT Country || ' ' || City || ' ' || Address || ' ' || PostalCode AS 주소 FROM Customers
SELECT ProductName AS 제품이름, Price || '가 ' || (Price*0.2) || '할인되어 ' || (Price*0.8) || '에 판매합니다!' AS 홍보문구 FROM Products;
SELECT * FROM CUSTOMERS WHERE CUSTOMERID BETWEEN 30 AND 50;
SELECT * FROM CUSTOMERS WHERE CUSTOMERID IN (10, 20, 30) ;
SELECT * FROM CUSTOMERS WHERE CUSTOMERID LIKE '_1';
_
: 문자열 1개에 해당%
: 글자수 상관X 모든 문자열(와일드카드)SELECT * FROM CUSTOMERS WHERE CUSTOMERID IS NULL;
5 & 7 = 5
, 5 | 7 = 7
왜일까!?