S_pot

SELECT addr FROM userTbl; SELECT DISTINCT addr FROM userTbl; SELECT TOP(10)CreditCardID FROM Sales.CreditCard --상위 10개만 출력 WHERE CardType = 'Vista' ORDER BY ExpYear, ExpMonth; SELECT TOP(0.1) PERCENT CreditCardID, ExpYear, ExpMonth -- 상위 0.1%만 출력 FROM Sales.CreditCard WHERE CardType = 'Vista' ORDER BY ExpYear, ExpMonth;

SELECT name, height FROM userTbl WHERE height > 177; SELECT height FROM userTbl WHERE name = '김경호'; -- 하드코딩 SELECT height FROM userTbl WHERE height >(SELECT height FROM userTbl WHERE name = '김경호'); -- 서브쿼리 -- 경남사람의 키는 173, 170이다. SELECT Name, height FROM userTbl WHERE height >= ANY -- 173보다 크거나 170보다 큰사람 = 173보다 큰사람 (SELECT height FROM userTbl WHERE addr = '경남'); SELECT Name, height FROM userTbl..

SELECT Name, height FROM usertbl WHERE height BETWEEN 180 AND 183; -- BETWEEN...AND SELECT * FROM userTbl WHERE addr IN('경남', '전남', '경북'); -- IN() SELECT Name, height FROM userTbl WHERE name LIKE '김%'; SELECT Name, height FROM userTbl WHERE name LIKE '_종신';

SELECT * FROM userTbl WHERE height >= 170 and height