Programming/MySql
Sql 상위 몇개만 쿼리
생각하는로뎅
2013. 10. 4. 02:02
반응형
> 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;
반응형