Query limit rows in database

[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!