orderby
orderby列表
-
说一下mysql, oracle等常见数据库的分页实现方案
1.Oracle:select * from ( select row_.*, rownum rownum_ from ( query_SQL ) row_ where rownum =< max) where rownum_ >= min2.SQL Server:select top @pagesize... [orderby]
1.Oracle:select * from ( select row_.*, rownum rownum_ from ( query_SQL ) row_ where rownum =< max) where rownum_ >= min2.SQL Server:select top @pagesize... [orderby]