请教一个简单的SQL语句

[snower01]

数据库是ACCESS
id f_date f_xnew
1 2005-1-1 ……
2 2005-1-1 ……
3 2005-1-1 ……
4 2005-1-5 ……
5 2005-1-5 ……
……
现在，我想取出最后同一时间的内容，按照顺序进行排列。下面的SQL语句应该怎样写？
sql = "select * from 表 group by f_date order by f_date,id desc"

[raline]

sql = "select * from 表名 order by f_date,id"
先按f_date排,再按id排
如果要倒序 sql = "select * from 表名 order by f_date desc,id desc"
order只要一个,desc是跟在要排序的段名后

[snower01]

已解决！
select * from table where f_date = (select max(f_date) from table) order by id desc

[skc_2004]

参与、学习

[baiyunfei]

mark

[redstorm11]

up

[61]

select * from table where DatePart(day,f_date) = DatePart(day,(select max(f_date) from table)) order by id