怎么样取最新的20条记录?

[zhujiechang]

有一个表,日期字读writedate,根据它取最新的20条记录.该字段无索引
在线等

[viptiger]

select top 20 * from YouTable order by writedate desc

[SilverSands]

select top 20 * from Table order by writedate desc

[friendliu]

select top 20 * from tablename
order by writedate desc

[aierong]

ok

[zjcxc]

select top 20 * from 表
order by writedate desc

[伍子V5]

必须要有时间字段或标识字段

select top 20 * from 表 order by 时间字段或标识字段 desc

[zhujiechang]

我也试过这种方式,但我不知道为什么可以,sql server对于order by排序的原则是什么?