Oracle
select id, age from (select id, age, rownum as rn from customer order by age) where rn between :m and :nMySql
select * from customer order by age limit :m, :n - :mMS SQL
I don't know how to do it with MS sql server yet. I don't have ms sql server installed. If you happen to know it, please post your solution in the comment.
No comments:
Post a Comment