Question

access数据库中如何按当前时间排序？紧急！知道麻烦告诉我！！

access数据库中按当前时间排序，sql语句如何写？ id time 1 2010-6-5 9:00:00 2 2010-6-5 9:30:00 3 2010-6-5 10:00:00 4 2010-6-5 10:30:00 5 2010-6-5 11:00:00 比如当前时间是2010-6-5 10:00:00那么排序就是34521

Answer 1

select *from (select top 100 *from tableName where time < getdate() order by time desc )