样把这两个SQL语句写成一个SQL? select sum(zcs) as cs from z_testselect sum(zcs) as gcs from z_test where z='hn' 怎样把这两个SQL语句写成一个SQL? 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 光一个union all也不够啊,那查出来不是两条记录了? select sum(zcs) as cs, case z='hn' then sum(zcs) as gcs end from z_test 未测,你试试 应该是这样select sum(zcs) as cs, case when z='hn' then sum(zcs) end as gcs from z_test 未测,你试试 select sum(a) cs, sum(b) gcs from (select zcs a,case when (z='hn') then zcs else 0 end as b from z_test) t这个测过了 SELECT * FROM(select sum(zcs) as cs from z_testselect sum(zcs) as gcs from z_test where z='hn')A SELECT * FROM(select sum(zcs) as cs from z_testUNION ALLselect sum(zcs) as gcs from z_test where z='hn')A dinoalex的解是符合我要求的正解,fa_ge的不行。 有了BitmapBuf和BitmapInfo等,有什么方法转为jpeg格式的内存流? 帮忙看一下是否有未释放的资源 讨论一下控件的版权问题 SOS!!~~~!! 工资管理系统的公式计算 请教高手:如何用快捷键调用过程 为什么我动态更新TClientDataSet的CommandText老是出错 delphi 如何实现多账号添加程序 richedit中的内容出现乱码,字体也会变掉,怎么回事? 有谁知道这个函数吗?MessageBoxIndirect。。。。 读取注册表键值的问题。 关于进销存架构问题,高手们进来发表高见啦~~~
(select zcs a,case when (z='hn') then zcs else 0 end as b from z_test) t这个测过了
(
select sum(zcs) as cs from z_test
select sum(zcs) as gcs from z_test where z='hn'
)A
SELECT * FROM
(
select sum(zcs) as cs from z_test
UNION ALL
select sum(zcs) as gcs from z_test where z='hn'
)A