34,590
社区成员
发帖
与我相关
我的任务
分享
declare @t table(sheet_no varchar(2),[money] numeric(12,2),flag char(1))
insert @t select 'A1',200.0000,'A'
insert @t select 'A1',200.0000,'B'
insert @t select 'A2',400.0000,'A'
insert @t select 'A2',400.0000,'B'
insert @t select 'A3',600.0000,'A'
--------------------------------
select distinct sheet_no,money
from @t
compute sum(money)
select sum(money) from
(select distinct sheet_no,money from @t) a
select sum(money)
from @t t
where not exists(select 1 from @t where sheet_no = t.sheet_no and flag> t.flag)
/*
sheet_no money
-------- --------------
A1 200.00
A2 400.00
A3 600.00
sum
========================================
1200.00
(所影响的行数为 4 行)
----------------------------------------
1200.00
(所影响的行数为 1 行)
----------------------------------------
1200.00
(所影响的行数为 1 行)
8/
select sum(money)
from @t t
where not exists(select 1 from @t where sheet_no = t.sheet_no and flag> t.flag)
select @i = sum(money) from
(select distinct sheet_no,money from @t) a
select @i
select @i = sum(distinct money) from @t
declare @i as decimal(18,2)
select @i = sum(money) from
(select distinct sheet_no,money from @t) a
select @i
or
select @i = sum(distinct money) from @t
select @i
select sum(money) from
(select distinct sheet_no,money from @t) a
or
select sum(distinct money) from @t
declare @i as decimal(18,2)
select @i = sum(money) from p