sql语句简单面试题.docVIP

sql语句简单面试题 篇一：SQL语句面试题 1.一道SQL语句面试题，关于group by 表内容： 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(#39;2005-05-09#39;,#39;胜#39;) insert into #tmp values(#39;2005-05-09#39;,#39;胜#39;) insert into #tmp values(#39;2005-05-09#39;,#39;负#39;) insert into #tmp values(#39;2005-05-09#39;,#39;负#39;) insert into #tmp values(#39;2005-05-10#39;,#39;胜#39;) insert into