请教:如何选择最新的8条记录并随机显示? select top 1 * from (select top 8 * from table1 order by uptime desc) tem order by newid() 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 select top 1 * from (select top 8 * from table1 order by uptime desc) tem order by newid() select top 1 * from (select top 8 * from table1 order by uptime desc) tem order by newid() declare @sqlset @sql='select top 1 * from (select top '+ltrim(str(round(rand()*8,0)+1))+' * from table1 order by uptime)'exec @sql select top 1 * from (select top 8 * from table1 order by uptime desc) tem order by newid() select top 1 * from table1 where uptime in((select top 8 uptime from table1 order by uptime desc)order by newid() select top 1 * from (select top 8 * from table order by uptime desc) aorder by newid() 这种约束应该怎么写? 新建存储过程问题 求一SQL语句 [紧急求救]sql server 2005企业版分区失败请教。 请教怎么处理xml数据 请问如何更改数据库的结构而不影响以前的数据? 在SQL Server 7.0中关于datatime类型数据的问题 请问用户定义函数的执行方式 请问哪位兄弟有用于加密密码的函数? mysql查询年龄大于20岁的前5名的平均成绩 如何在SQLServer中打印查询出的东西 SQL Server 2000在单机上能装吗?
set @sql='select top 1 * from (select top '+ltrim(str(round(rand()*8,0)+1))+' * from table1 order by uptime)'
exec @sql
select top 1 * from table1 where uptime in(
(select top 8 uptime from table1 order by uptime desc)
order by newid()
order by newid()