1、select top 10 * from tablename order by id desc(有id自增字段用这个最好) 2、select * from tablename where datediff(dd,时间字段,getdate())<=2
1、select top 10 * from tablename order by 时间字段 desc select top 10 * from tablename order by 标识字段 desc2、select * from tablename where datediff(day,时间字段,getdate())<=2
1 select top 10 * from tablename order by 自增加字段 desc2 select * from tablename where datediff(day,时间字段,getdate())<=2
1,最近的10条记录?select top 10 * from 表 order by 修改时间 desc2,最近2天内的全部记录? select * from 表 where datediff(day,修改时间,getdate()) between 0 and 2
2、select * from tablename where datediff(dd,时间字段,getdate())<=2
select top 10 * from tablename order by 标识字段 desc2、select * from tablename where datediff(day,时间字段,getdate())<=2
select top 10 *
from tablename
order by 自增加字段 desc2
select *
from tablename
where datediff(day,时间字段,getdate())<=2
select * from 表 where datediff(day,修改时间,getdate()) between 0 and 2