With orderlist as (SELECT ROW_NUMBER() OVER (ORDER BY RegTime) AS RowNumber,* FROM G_Trade_TradeList)--定义SQL查询片段 根绝条件筛选之后的数据
select *,(select count(*) from orderlist )as count
from orderlist
where RowNumber between (convert(int,当前页数)-1)* convert(int,分页条数)+1 and (convert(int,当前页数) * convert(int,分页条数) )