select dqdl ,sum(CASE xg WHEN '超市' THEN (select sum(je) as kk from test) ELSE 0 END) AS '超市'
from xxx
group by dqdl
or select dqdl ,count(CASE xg WHEN '超市' THEN 1 ELSE 0 END) AS '超市'
from xxx
group by dqdl
from xxx
group by dqdl
or select dqdl ,count(CASE xg WHEN '超市' THEN 1 ELSE 0 END) AS '超市'
from xxx
group by dqdl
楼上的写法好像不太对?
from xxx
group by dqdl
这样可以吗?