/// <summary>
///分页sql
/// </summary>
/// <param name="sql">查询内容的sql</param>
/// <param name="order">排序字段(降序),必须是查出的某个字段</param>
/// <param name="pageNumebr">页码</param>
/// <param name="pageSize">每页的数量</param>
/// <returns></returns>
public static string SqlToPage(string sql, string order, int pageNumebr, int pageSize)
{
string psql = @"select * from(
SELECT * FROM(
select row_number() OVER(order by Q." + order + @" desc) ROWIDS, Q.*, COUNT(*) OVER() TOTAL from(" + sql + @") Q
)
WHERE ROWIDS <= " + (pageNumebr * pageSize) + @") TABS
WHERE TABS.ROWIDS > " + (pageNumebr - 1) * pageSize;
return psql;
}
string sql="select name,id,time from table1"
SqlToPage(sql,"time",1,10);