一、查询条件
1.日期类型
(1)查询当日数据:
Select * from tableName where DATEDIFF(DAY, FCreateDate,GETDATE())=0
(2)查询90日内数据:
Select * from tableName where BETWEEN DATEADD(DAY, -90, GETDATE())
2.前N条数据
(1)查询班级最高分
Select top 1 from tableName where class='3' order by score desc
3.条件判断
(1)存在则更新,不存在则新增
if not exists (select 1 from tableName1 where name=? ) insert into tableName1(name) values(?) else update tableName1 set name=?,updatetime=getdate() where name=?