Sql 상위 몇개만 쿼리

> SQL Server :

SELECT TOP 10 name, email, phone 

FROM userinfo

> ORACLE :

SELECT name, email, phone

FROM userinfo 

WHERE ROWNUM <= 10

> MySQL :

SELECT name, email, phone

FROM userinfo

LIMIT 10

>SqlCE

SELECT TOP(10) * 

FROM TableName;

(http://technet.microsoft.com/en-us/library/bb686896.aspx)