Question

用SQL语句查询如图的表的结果！！谢谢！自己学的都还给老师了~~~

表数据：
table: Competition

查询结果：





Answer 1

select date,sum(case result when '胜' then 1 else 0) 胜,
sum(case result when '负' then 1 else 0) 负
group by date

追问

sql server2005不能运行，提示“)”处有错误~

追答

select date,sum(case result when '胜' then 1 else 0) as [胜],
sum(case result when '负' then 1 else 0) as [负]
group by date

Answer 2

select DATE,
count(case when result = '胜' then result end ) '胜',
count(case when result = '负' then result end) '负'
from competition
group by date

Answer 3

select date,sum(case when result='胜' then 1 else 0 end) as 胜,sum(case when result='负' then 1 else 0 end) as 负
from Competition group by date

Answer 4

select date, sum(decode(result,'胜',1,0)),sum(decode(result,'负',1,0))
from Competition group by date

Answer 5

select date,sum(case result when '胜' then 1 else 0 end) 胜,
sum(case result when '负' then 1 else 0 end) 负 from Competition
group by date