SQL经典面试题及答案.doc

文档介绍：SQL经典面试题及答案
胜胜负负胜负负
一道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(lO), shengfu nchar(l))
insert into #tmpinsert into #tmp
values (，2005-05-09, J 胜')
values (，2005-05-09, J 胜')
insert
insert
insert
into #tmp values (' 2005-05-09,，'负') into #tmp values (' 2005-05-09,，'负')
insert into #tmpinsert into #tmp
values (，2005-05-10, J 胜')
values (，2005-05-10, J 负')
into #tmp values ('2005-05-10','负')
select rq, sum (case when shengfu='胜'then 1 else 0 end)'胜'，sum (case when shengfu='负'then 1 else 0 end)'负'from #tmp group by rq
select N. rq, ,M. from (
select rq,媵二count (*) from #tmp where shengfu='胜'group by rq)N inner join
(select rq, =count (*) from #tmp where shengfu='负'group by rq)M on
N. rq=M. rq
select a. colOOl, a. al 胜,b・bl 负 from
(select colOOl, count (colOOl) al from tempi where col002='胜'group by colOOl) a,
(select colOOl, count (colOOl) bl from tempi where col002='负'group by colOOl) b
where a. colOOl=b・ colOOl
请教一个面试中遇到的SQL语句的查询问题
表中有ABC三列，用SQL语句实现：当A列大于B列时选择A列否则选择B列, 当B列大于C列时选择B列否则选择C列。
select (case when a>b then a else b end ), (case when b>c then b esle c end) from table name
面试题：一个日期判断的sql语句？
请取出tb send表中日期(SendTime字段)为当天的所有记录？ (SendTime字段为 datetime型，包含日期与时间) select * from tb where datediff (dd, SendT