Query limit rows in database

[Sam Wang]

[mysql]
select * from XXXtable limit [offset,] rows
[oracle]
select * from XXXtable where rownum < rowindex
[sqlserver]
select * top rows from XXXtable
In my opinion,mysql is the best at this function!

[Jamie Robertson]

OR in java for all three databases:

Statement s = conn.createStatement();
s.setMaxRows( limit );
ResultSet rs = rs.executeQuery( "SELECT * FROM XXXtable" );

In my opinion, this is the best way so you're not finding/changing all your queries when you change databases!
Jamie

[Sam Wang]

You are a good Man.Thanks.