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