aa bb cc dd
001 1 2 ad
002 3 5 de
001 36 25 asd
003 3 23 asdf
001 12 2 de
002 5 3 de
如何查询出:
aa bb cc dd
001 49 2 ad
002 8 5 de
003 3 23 asdf
就是条件汇总了,怎么写sql语句呀?
...全文
2614打赏收藏
我真的好菜~送点分给大家吧~~
表:kk aa bb cc dd 001 1 2 ad 002 3 5 de 001 36 25 asd 003 3 23 asdf 001 12 2 de 002 5 3 de 如何查询出: aa bb cc dd 001 49 2 ad 002 8 5 de 003 3 23 asdf 就是条件汇总了,怎么写sql语句呀?
GROUP BY 子句:
指定用来放置输出行的组,并且如果 SELECT 子句 <select list> 中包含聚合函数,则计算每组的汇总值。指定 GROUP BY 时,选择列表中任一非聚合表达式内的所有列都应包含在 GROUP BY 列表中,或者 GROUP BY 表达式必须与选择列表表达式完全匹配
select aa, (select sum(bb) from kk where aa = A.aa) as bb, cc, dd from kk as A
where cast(cc as varchar) + dd =
(select top 1 cast(cc as varchar) + dd from kk where aa = A.aa)
select aa, (select sum(bb) from kk where aa = A.aa) as bb, cc, dd from kk as A
where cast(cc as varchar) + dd in
(select top 1 cast(cc as varchar) + dd from kk where aa = A.aa)