DB/DB common
ROWNUM, TOP, LIMIT
냐옴
2015. 10. 22. 10:44
--Oracle
SELECT *
FROM AATEST
WHERE ROWNUM <= 3
;
--MS-SQL Server
SELECT TOP 3 *
FROM AATEST
;
--MySQL
SELECT *
FROM AATEST
LIMIT 3
;