SQL Server 分页SQL 

1 SELECT * FROM(SELECT ROW_NUMBER() OVER(order by Id DESC)AS rownum, 
2                                   (SELECT COUNT(*) FROM Ana_Strategy  WHERE UploadTime BETWEEN @EgyStatime AND  @EgyEndtime )AS TotalCount, 
3                                   * from Ana_Strategy) as t 
4                                      WHERE t.UploadTime BETWEEN  @EgyStatime AND  @EgyEndtime
5                                           AND  t.rownum BETWEEN  @paGeSize *( @PageIndex -1)+1 and @PageIndex* @paGeSize

 

posted @ 2019-07-27 15:31  Provedl  阅读(322)  评论(0)    收藏  举报