sql分页

来源:互联网 发布:ad7606中文数据手册 编辑:程序博客网 时间:2024/06/15 06:34
public static final String MYSQL_SQL = "select * from ( {0}) sel_tab00 limit {1},{2}";         //mysqlpublic static final String POSTGRE_SQL = "select * from ( {0}) sel_tab00 limit {2} offset {1}";//postgresqlpublic static final String ORACLE_SQL = "select * from (select row_.*,rownum rownum_ from ({0}) row_ where rownum <= {1}) where rownum_>{2}"; //oraclepublic static final String SQLSERVER_SQL = "select * from ( select row_number() over(order by tempColumn) tempRowNumber, * from (select top {1} tempColumn = 0, {0}) t ) tt where tempRowNumber > {2}"; //sqlserver
0 0
原创粉丝点击