有如下一个表bisai
racedate result
2009-07-16 胜
2009-07-16 胜
2009-07-16 负
2009-07-17 胜
2009-07-17 负
2009-07-17 胜
2009-07-17 负
写个sql语句,要求输出结果为:
RACEDATE 胜 负
2009-07-16 2 1
2009-07-17 2 2谢谢,先睡个觉,明天起来结帖
racedate result
2009-07-16 胜
2009-07-16 胜
2009-07-16 负
2009-07-17 胜
2009-07-17 负
2009-07-17 胜
2009-07-17 负
写个sql语句,要求输出结果为:
RACEDATE 胜 负
2009-07-16 2 1
2009-07-17 2 2谢谢,先睡个觉,明天起来结帖
select sum(decode(result ,'胜',1,0)) 'sheng',sum(decode(result ,'负,1,0)),RACEDATE from bisai group by RACEDATE
sum(decode(result,'胜',1,0)),
sum(decode(result,'负',1,0))
from bisai
group by racedate
group by加了,不需要distinct了