求 SQL 语句3

gagaxiaoyuer 2007-12-21 11:38:51

hum yongdd jubh dushu
汪应区香园香山阁4-702 DDZ011093 1966
汪应香香山阁4幢702 DDZ011093 2038.5
张美颐景苑I3幢101房 DDZ013904 10829
张美 I3幢101房 DDZ013904 10604
邱钰 F4-24-302 DDZ013906 2377
邱钰 F4-24幢1-2梯302 DDZ013906 2377.32
邱钰 F4-24栋1-2梯202 DDZ013907 1359.05
邱钰 24栋202 DDZ013907 1181
邱晓 F4-24栋1-2梯401 DDZ013910 3036
邱晓 F4-24栋1-2梯401 DDZ013910 3115

如何比较dushu 这列的的差额条件是 jubh 相同

...全文

100 14 打赏收藏转发到动态举报

写回复

用AI写文章

14 条回复

切换为时间正序

请发表友善的回复…

发表回复

leisure_cool 2007-12-21

打赏
举报



begin

declare @T_table table(hum varchar(10),yongdd varchar(50),jubh varchar(20),dushu decimal(8,2))

insert into @T_table values 

('汪应','区香园香山阁4-702','DDZ011093',1966)

insert into @T_table values

('汪应','香香山阁4幢702','DDZ011093',2038.5)

insert into @T_table values

('张美','颐景苑I3幢101房','DDZ013904',10829)

insert into @T_table values

('张美','I3幢101房','DDZ013906',2377)

insert into @T_table values

('邱钰','F4-24-302','DDZ013906',2377)   

insert into @T_table values

('邱钰','F4-24幢1-2梯302','DDZ013906',2377.32)   

insert into @T_table  values

('邱钰','F4-24栋1-2梯202','DDZ013907',1359.05)

insert into @T_table values

('邱钰','24栋202','DDZ013907',1181)   

insert into @T_table values

('邱晓','F4-24栋1-2梯401','DDZ013910',3036)

insert into @T_table  values

('邱晓','F4-24栋1-2梯401','DDZ013910',3115)  

end 

select max(dushu)-min(dushu) as cha,jubh from @T_table group by jubh

wzy_love_sly 2007-12-21

打赏
举报

常来csdn吧lz,这里比我厉害的太多了

wzy_love_sly 2007-12-21

打赏
举报

select jubh ,.....我自己测试用的b

gagaxiaoyuer 2007-12-21

打赏
举报

那你答应我看见我有难就得帮我哈哈。select b,max(dushu )-min(dushu ) as cha from tb group by jubh b 这地方有点问题

wzy_love_sly 2007-12-21

打赏
举报

select b,max(dushu  )-min(dushu  ) as cha from tb group by jubh

gagaxiaoyuer 2007-12-21

打赏
举报

如何比较dushu 这列的的差额条件是 jubh 相同

wzy_love_sly 2007-12-21

打赏
举报

我公司不许上qq,诶
你自己学吧，好好学很快，我也才来论坛1个月

gagaxiaoyuer 2007-12-21

打赏
举报

wzy_love_sly wzy_love_sly wzy_love_sly 你可以加我QQ 好吗 QQ： 191388736 做个朋友向你学东西

liangCK 2007-12-21

打赏
举报

没看懂.

gagaxiaoyuer 2007-12-21

打赏
举报

快揭贴，是什么意思哈哈我刚来论坛不知道这些

wzy_love_sly 2007-12-21

打赏
举报

快揭贴，小鸟同志

gagaxiaoyuer 2007-12-21

打赏
举报

select b,max(dushu )-min(dushu ) as cha from tb group by jubh 这句是我要的谢谢大家。

-狙击手- 2007-12-21

打赏
举报

declare @T_table table(hum varchar(10),yongdd varchar(50),jubh varchar(20),dushu decimal(8,2))

insert into @T_table values 

('汪应','区香园香山阁4-702','DDZ011093',1966)

insert into @T_table values

('汪应','香香山阁4幢702','DDZ011093',2038.5)

insert into @T_table values

('张美','颐景苑I3幢101房','DDZ013904',10829)

insert into @T_table values

('张美','I3幢101房','DDZ013906',2377)

insert into @T_table values

('邱钰','F4-24-302','DDZ013906',2377)   

insert into @T_table values

('邱钰','F4-24幢1-2梯302','DDZ013906',2377.32)   

insert into @T_table  values

('邱钰','F4-24栋1-2梯202','DDZ013907',1359.05)

insert into @T_table values

('邱钰','24栋202','DDZ013907',1181)   

insert into @T_table values

('邱晓','F4-24栋1-2梯401','DDZ013910',3036)

insert into @T_table  values

('邱晓','F4-24栋1-2梯401','DDZ013910',3115) 



select identity(int,1,1) as id ,* into # from @t_table



select a.*,[差]=isnull(a.dushu,0) - COALESCE(b.dushu,a.dushu)

from # a

left join # b on a.id = b.id + 1 and a.jubh = b.jubh 

drop table #

/*





id          hum        yongdd                                             jubh                 dushu      差           

----------- ---------- -------------------------------------------------- -------------------- ---------- ----------- 

1           汪应         区香园香山阁4-702                                        DDZ011093            1966.00    .00

2           汪应         香香山阁4幢702                                          DDZ011093            2038.50    72.50

3           张美         颐景苑I3幢101房                                         DDZ013904            10829.00   .00

4           张美         I3幢101房                                            DDZ013906            2377.00    .00

5           邱钰         F4-24-302                                          DDZ013906            2377.00    .00

6           邱钰         F4-24幢1-2梯302                                      DDZ013906            2377.32    .32

7           邱钰         F4-24栋1-2梯202                                      DDZ013907            1359.05    .00

8           邱钰         24栋202                                             DDZ013907            1181.00    -178.05

9           邱晓         F4-24栋1-2梯401                                      DDZ013910            3036.00    .00

10          邱晓         F4-24栋1-2梯401                                      DDZ013910            3115.00    79.00



（所影响的行数为 10 行）

*/