Re: [SQL ] SQL指令的问题请教

楼主: bulmungtw (Lance)   2014-05-14 16:04:36
※ 引述《hhomerun (HOMERUN家族弟弟)》之铭言:
: 其实很简单, 你把他想得太复杂了~
: SELECT [ID]
: ,min([TYPE]) [TYPE]
: ,SUM([VAL]) [VAL]
: FROM [test].[dbo].[table]
: GROUP BY [ID]
: 技巧在min那边, 要显示A 就用min, 要显示B 就用max
: 希望鲁蛇的答案对你有帮助QQ
谢谢帮忙!!
后来请同事帮忙 艸
SELECT [ID], 'A', sum([VAL])
from [TABLE]
where
[ID] IN (
select [ID]
from [TABLE]
where [DATE] = '2014/05/13'
group by [ID]
HAVING COUNT(*)>1
)
group by [ID]
UNION
SELECT [ID], risk_kind, sum([VAL])
from [TABLE]
where [ID] IN (
select [ID]
from [TABLE]
where [DATE] = '2014/05/13'
group by [ID]
HAVING COUNT(*)=1
)
group by [ID], risk_kind
只是目前要查的资料会让ID重复的只有同ID同时有A与B两笔资料的状况
以外的刚好不会(希望未来也不要会…………会的话这样的判断就不对了)
所以这样做就解决了T_T
总之谢谢大家!!
作者: lin1987www (林奕忠)   2014-05-14 18:26:00
同事OP
作者: hhomerun (HOMERUN家族弟弟)   2014-05-15 00:05:00
哈哈 不用那么复杂的

Links booklink

Contact Us: admin [ a t ] ucptt.com