DB 별 ROWNUM = 1

Oracle / Tibero

select * from tableName where rownum = 1;

Mssql

select top 1 * from tableName;

Informix

select first 1 * from tableName;

Sybase

select * from tableName where rowid(tableName) between 1 and 1;

Altibase / MySQL

select * from tableName limit 1;

DB2

select * from tableName fetch first 1 row only;

출처: http://extremeblue.tistory.com/12 [extremeblue's blues]