查询最近n天的记录.txt

学习积累的代码段

select   * from Mysealgoods  where month(Mygoodstime)=month(getdate())-1选取一个月前的记录
几个月就减几


最近1天:   
  select   *   from   table1   where   datediff(day,datefield,getdate())   =   0     
    
  最近2天:   
  select   *   from   table1   where   datediff(day,datefield,getdate())   <=   1   and   datediff(day,datefield,getdate())   >=0   
    
  最近3天:   
  select   *   from   table1   where   datediff(day,datefield,getdate())   <=   2   and   datediff(day,datefield,getdate())   >=   0     
    
  最近一个星期:   
  select   *   from   table1   where   datediff(day,datefield,getdate())   <=     6   and   datediff(day,datefield,getdate())   >=   0   

查询最近10天的记录

-n 前n天
+n 后n天
这是按天算的 
  Mygoodstime>dateadd(d,-10,getdate())