SELECT a,Sum(b) as Sumb, c, d, Sum(e) as Sume FROM ( SELECT ROW_NUMBER() OVER (order by T.a desc)AS Row, T.* from Tabels T ) as TT group by a, c, d 这里查询出来的总记录数是23条, 我加个between 用来分页, SELECT a,Sum(b) as ... SELECT a,Sum(b) as Sumb, c, d, Sum(e) as Sume FROM ( SELECT ROW_NUMBER() OVER (order by T.a desc)AS Row, T.* from Tabels T ) as TT group by a, c, d 这里查询出来的总记录数是23条, 我加个between 用来分页, SELECT a,Sum(b) as Sumb, c, d, Sum(e) as Sume FROM ( SELECT ROW_NUMBER() OVER (order by T.a desc)AS Row, T.* from Tabels T ) as TT WHERE TT.Row between 1 and 15 group by a, c, d 查询出来的记录数第一页只有13条? 然后再查询第二页 SELECT a,Sum(b) as Sumb, c, d, Sum(e) as Sume FROM ( SELECT ROW_NUMBER() OVER (order by T.a desc)AS Row, T.* from Tabels T ) as TT WHERE TT.Row between 16 and 30 group by a, c, d 只有8条?分页是按Tabels 来查的还是怎么查询的?请教下SQL如何写, 展开