1,195
社区成员
发帖
与我相关
我的任务
分享再线等待，请问INFROMIX里用UNION ALL连接时能否用ORDER BY 【排序？谢谢
我的语句
select a.kinds,a.kind_name,sum(c.u_pnum),count(c.bm_unit),sum(c.u_premium),sum(c.u_amount） from kind_spec a,outer c where a.kinds=c.kinds and c.bnch_adm='01' and a.kinds in(124,115 )
group by a.kinds,a.kind_name '总计','', sum(c.u_pnum) as aa,count(c.bm_unit),sum(c.u_premium),sum(c.u_amount) from kind_spec a,outer c where a.kinds=c.kinds and c.bnch_adm='01' and a.kinds in(124,115 )
再这里我想用A.KINDS排序，怎么做啊？谢谢 啊ORDER BY 放在那里呢？
select a.kinds,a.kind_name,sum(c.u_pnum),count(c.bm_unit),sum(c.u_premium),sum(c.u_amount） from kind_spec a,outer c where a.kinds=c.kinds and c.bnch_adm='01' and a.kinds in(124,115 )
group by a.kinds,a.kind_name '总计','', sum(c.u_pnum) as aa,count(c.bm_unit),sum(c.u_premium),sum(c.u_amount) from kind_spec a,outer c where a.kinds=c.kinds and c.bnch_adm='01' and a.kinds in(124,115 )
再这里我想用A.KINDS排序，怎么做啊？谢谢 啊ORDER BY 放在那里呢？
...全文
请发表友善的回复…
发表回复
tyffly 2004-06-29
- 打赏
- 举报
order by 放在最后
ordre by 1
ordre by 1
