能否让表按“日期”排序？

[ShingU]

目的是找出最近日期的那条记录。

[hsj20041004]

俩种方法均可以！！！
但是这种方法比较好
select top 1 * from tb order by datecol desc

[jinci]

如果用select * from tb order by datecol desc limit 1不行吗？

[talantlee]

我不答問題，拿分可以嗎，哈

[ShingU]

原来就这么简单啊！谢谢了！:)

[wyb0026]

select * from tb where date in( select max(date) from tb)

[xluzhong]

select top 1 * from tb order by datecol desc