select w2.n,w1.* from Record w1,(select top 2 ROW_NUMBER() over ( ORDER BY ID ASC) n,id from Record WHERE 操作员='admin' and 类型='上分') w2 where w1.id = w2.id and w2.n>0 order by w2.n asc
比如这个语句,我要如何求助 这里面 列名为 额度 的总数 ,
...全文
3737打赏收藏
sql语句分页如何使用sum、count语句
select w2.n,w1.* from Record w1,(select top 2 ROW_NUMBER() over ( ORDER BY ID ASC) n,id from Record WHERE 操作员='admin' and 类型='上分') w2 where w1.id = w2.id and w2.n>0 order by w2.n asc 比如这个语句,我要如何求助 这里面 列名为 额度 的总数 ,
select w2.n,w1.*,sum(额度) over() as total from Record w1,(select top 2 ROW_NUMBER() over ( ORDER BY ID ASC) n,id from Record WHERE 操作员='1' and 类型='下分') w2 where w1.id = w2.id and w2.n>0 order by w2.n asc
可以了 ,谢谢 ,调整成这样就可以了
select w2.n,w1.* from Record w1,(select top 2 ROW_NUMBER() over ( ORDER BY ID ASC) n,id from Record WHERE 操作员='admin' and 类型='上分') w2 where w1.id = w2.id and w2.n>0 order by w2.n asc
这是一个分页查询的SQL语句,我想要求助这一页中,一列的 和 , 字段为 : 额度 ,就是要把 sum(额度),加到这个语句里面求出来
select w2.n,w1.* from Record w1,(select top 2 ROW_NUMBER() over ( ORDER BY ID ASC) n,sum('额度') over() as total,id from Record WHERE 操作员='admin' and 类型='上分') w2 where w1.id = w2.id and w2.n>0 order by w2.n asc