请教：如何选择最新的8条记录并随机显示？

[Raimond]

有个表table1，里面有列uptime
我想根据时间从最新的8条记录中随机选中其中的1条。这个语句该怎么写？

[CrazyFor]

select top 1 * from (select top 8 * from table1 order by uptime desc) tem order by newid()

[CrazyFor]

select top 1 * from (select top 8 * from table1 order by uptime desc) tem order by newid()

[CrazyFor]

select top 1 * from (select top 8 * from table1 order by uptime desc) tem order by newid()

[pbsql]

declare @sql
set @sql='select top 1 * from (select top '+ltrim(str(round(rand()*8,0)+1))+' * from table1 order by uptime)'
exec @sql

[pengdali]

select top 1 * from (select top 8 * from table1 order by uptime desc) tem order by newid()

[zjcxc]

select top 1 * from table1 where uptime in(
(select top 8 uptime from table1 order by uptime desc)
order by newid()

[happydreamer]

select top 1 * from (select top 8 * from table order by uptime desc) a
order by newid()

[Raimond]

搞定了。谢谢！