SQL_DISTINCT, TOP(N)

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;