develog

ROWNUM, TOP, LIMIT 본문

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

;



저작자표시

'DB > DB common' 카테고리의 다른 글

[DB] DB version  (0) 2017.04.25
[DB] DDL, DML, DCL  (0) 2017.03.27
[jdbc] jdbc, driver, connection url  (0) 2016.06.02
Configuring Connection Pooling in Tomcat  (0) 2013.03.07
rownum, top, limit  (0) 2013.03.06
'DB/DB common' Related Articles more
Comments