在查询结果集中进行统计

zljqf 2006-07-28 08:43:41

下面语句是查询m,o两个表，先查询出满足条件的keycode,Right_Value两个字段不重复的记录，然后从这个记录集中求和Right_Value
能不能一条语句就写出来？

SELECT distinct m.keycode,m.Right_Value into #tmp
FROM Operation o INNER JOIN
Mortagage m ON o.KeyCode = m.KeyCode
WHERE convert(datetime,o.archives_date) between '2006-07-5' and '2006-07-27'
go
select sum(Right_Value) as sumvalue from #tmp
go
drop table #tmp

...全文

146 1 打赏收藏转发到动态举报

写回复

用AI写文章

1 条回复

切换为时间正序

请发表友善的回复…

发表回复

LouisXIV 2006-07-28

打赏
举报

select sum(Right_Value) as sumvalue
from
(
SELECT distinct m.keycode,m.Right_Value
FROM Operation o INNER JOIN
Mortagage m ON o.KeyCode = m.KeyCode
WHERE convert(datetime,o.archives_date) between '2006-07-5' and '2006-07-27'
)a