sql查询练习及答案

月的月日则,年龄减一 select *, case when right(convert(varchar(10),getdate(),120),5) < right(convert(varchar(10),sage,120),5) then datediff(yy , sage , getdate()) -1 else datediff(yy , sage , getdate()) end [ 年龄] from student --47 、查询本周过生日的学生 select * from student where datediff(week,datename(yy,getdate()) + right(convert(varchar(10),sage,120),6),getdate()) =0 --48 、查询下周过生日的学生 select * from student where datediff(week,datename(yy,getdate()) + right(convert(varchar(10),sage,120),6),getdate()) = -1 --49 、查询本月过生日的学生 select * from student where datediff(mm,datename(yy,getdate()) + right(convert(varchar(10),sage,120),6),getdate()) =0 --50 、查询下月过生日的学生 select * from student where datediff(mm,datename(yy,getdate()) + right(convert(varchar(10),sage,120),6),getdate()) = -1 drop table Student,Course,Teacher,SC