sql="select * from (select guest,sum(case sign=1 then 1 else 0 end ) as sign_1,sum(case sign=2 then 1 else 0 end ) from table where guest<>'' group by guest ) tem order by sign_1"
sql="select sign_1,sum(sign_2) from (select guest,sum(case sign=1 then 1 else 0 end ) as sign_1,sum(case sign=2 then 1 else 0 end ) sign_2 from table where guest<>'' group by guest ) tem order by sign_1"
不好意思 还有一个问题 我在这个语句里面还有group by ,我这么写 order by sign_1 group by other_sign 为什么 说我不对啊。 谢谢
group by other_sign order by sign_1
select guest,sum(case sign=1 then 1 else 0 end ) as sign_1,sum(case sign=2 then 1 else 0 end ) from table where guest<>'' group by sum(case sign=1 then 1 else 0 end )
select * from (select guest,sum(case sign=1 then 1 else 0 end ) [sign_1],sum(case sign=2 then 1 else 0 end ) [sign_2] from [你的表] where guest<>'' group by guest ) tem order by sign_1
还有一个问题
我在这个语句里面还有group by ,我这么写
order by sign_1 group by other_sign
为什么 说我不对啊。
谢谢