一条SQL语句的月总帐

来源：百度文库编辑：神马文学网时间：2024/04/28 22:16:20

create table temptb (mon int,value int)
insert temptb values (1,20)
insert temptb values (2,20)
insert temptb values (3,20)
insert temptb values (4,20)
insert temptb values (5,20)
insert temptb values (6,20)
insert temptb values (7,20)
insert temptb values (8,20)
insert temptb values (9,20)
insert temptb values (10,20)
insert temptb values (11,20)
insert temptb values (12,20)
declare @month int
set @month=1
while(@month<13)
begin
select sum(value) as value from temptb where mon<=@month
set @month=@month+1
end
go
select * from
(
select mon,value,‘月计‘ as summary from (select mon,sum(value) value from temptb group by mon) as temptb
union all
(select t2.mon,sum(t1.value) as value,‘累计‘ as summary from (select mon,sum(value) value from temptb group by mon) as t1 inner join (select mon,sum(value) value from temptb group by mon) as t2 on t1.mon>=t2.mon
group by t2.mon)
) a order by a.mon asc,a.value asc,a.summary desc
select * from temptb

一条SQL语句的月总帐常用的SQL语句最高的SQL语句关于SQL Server SQL语句查询分页数据的解决方案 Mssql - SQL Server 数据库管理常用的SQL语句 sql中为表加约束的sql语句检测mysql中sql语句的效率绝对精典的SQL语句绝对精典的SQL语句 [SQL]SQL语句分析集锦 SQL Server：用 SQL 语句一条高CPU语句的优化 SQL语法,SQL语句大全,SQL基础常用SQL语句词典精妙Sql语句 - 数据库精妙SQL语句整理精妙SQL语句整理 SQL 语句中的通配符常用sql语句学习 SQL语句大全 Transact-SQL语句总汇 SQL语句集锦 [转] 精妙SQL语句整理 Transact-SQL语句