能不能只打开最近的10个纪录?

[liglow]

我在做新闻站.如果直接是select * from news,那最后一定打开的极慢.能不能只打开最近的数个纪录?

[tddw]

select top 10 * from news
打开最近的10条

[swich]

select top 10 * from news

[Brookes]

select top 10 * from news order by newsTime desc 'or by 排序列

[sinusoid]

select top 10 *
from news
order by id desc

[purpleyl]

按id排序选10个

[hermit2003]

select top 10 * from [table] order by [datetime] desc

[sxsgssgs]

select top 10 * from news order by newsTime desc 'or by 排序列

[zhonggan]

select * from news order by ID desc

[zhonggan]

select top 10 * from news order by ID desc

[lixiufu]

select top 10 * from news order by Id desc

[blueice2002]

top 10

[vvfish119]

select top 10 * from news order by id desc