一道SQL语句题

Question

表内容：
2005-05-09 胜
2005-05-09 胜
2005-05-09 负
2005-05-09 负
2005-05-10 胜
2005-05-10 负
2005-05-10 负
如果要生成下列结果, 该如何写sql语句?
            胜 负
2005-05-09 2 2
2005-05-10 1 2
create table #tmp(rq varchar(10),shengfu nchar(1))
insert into #tmp values('2005-05-09','胜')
insert into #tmp values('2005-05-09','胜')
insert into #tmp values('2005-05-09','负')
insert into #tmp values('2005-05-09','负')
insert into #tmp values('2005-05-10','胜')
insert into #tmp values('2005-05-10','负')
insert into #tmp values('2005-05-10','负')

Answer 1

/*
DROP TABLE TMP;
CREATE TABLE TMP(RQ VARCHAR2(20),SHENGFU VARCHAR2(5));
INSERT INTO TMP VALUES('2005-05-09','胜');
INSERT INTO TMP VALUES('2005-05-09','胜');
INSERT INTO TMP VALUES('2005-05-09','负');
INSERT INTO TMP VALUES('2005-05-09','负');
INSERT INTO TMP VALUES('2005-05-10','胜');
INSERT INTO TMP VALUES('2005-05-10','负');
INSERT INTO TMP VALUES('2005-05-10','负');*/SELECT RQ,
       SUM(DECODE(SHENGFU, '胜', 1, 0)) AS 胜,
       SUM(DECODE(SHENGFU, '负', 1, 0)) AS 负
  FROM TMP
 GROUP BY RQ;
注意结贴.....

Answer 2

估计lz又去面试了多看看经典SQL大全吧