这个SQL要怎么实现？
TRADE_MONEYTERM_IDORG_IDORG_DESC
509387501010203开去营业
509387501010203开去营业
509387501010203开去营业
509835941010202配额营业
509835941010202配额营业
509835941010202配额营业
509835941010202配额营业
509387501010203开去营业
509387501010203开去营业
509387501010203开去营业
509387501010203开去营业
509387501010203开去营业
509387501010203开去营业
509387501010203开去营业
509387501010203开去营业
509387501010203开去营业
想得到如下这张表
org_idorg_desccountsum
1010203开去营业12600
1010202配额营业4200
*count为所选机构的记录数，sum为所选机构的trade_moeny和
传入的查询值为org_id in 1010203,1010202
谢谢
[解决办法]
select org_id,org_desc,count(*),sum(trade_moeny) from table
where org_id in ( '1010203 ', '1010202 ')
group by org_id,org_desc
这样就可以了吧!
[解决办法]
SELECT org_id, MIN(org_desc) AS org_desc, COUNT(*) AS cnt,
SUM(trade_money) AS sm
FROM table1
GROUP BY org_id
UNION ALL
SELECT NULL, NULL, COUNT(*), SUM(trade_money) FROM table1
[解决办法]
都取别名,上下一致
select org_id,org_desc,count(*) as count,sum(trade_moeny) as sum from table
where org_id in ( '1010203 ', '1010202 ')
group by org_id,org_desc
union all
select ' ' as org_id, ' ' as org_desc,COUNT(*) as count,SUM(trade_money) as sum FROM table1
