2006-07-19 SQLメモ 指定行を抽出する。 Oracle select * from test where rownum <= 5 order by key SQLServer select top 5 * from test order by keyselect top 5 * from test where key not in ( select top 10 key from test order by key ) order by key MySQL select * from test order by key offset 0 limit 5