SQL server怎么查询本周过生日的学生？

Question

 

Answer 1

 自己补充下表名：

SELECT * FROM 表 where

sage> DATEADD(wk, DATEDIFF(wk,0,DATEADD(dd, -1, getdate()) ), 0) and sage<DATEADD(wk, DATEDIFF(wk,0,DATEADD(dd, -1, getdate()) ), 7)