关于随机排序的问题,MM急求 select top 10 * from links order by newid(),id desc我想实现先随机选出10条纪录,这10条纪录再按id降序排上面的sql不能实现,请求高手给出正确语句 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 select * from links where id in(select top 10 id from links order by newid()) order by desc select * from (select top 10 id from links order by newid())a order by a.id desc --用子查询select * from (select top 10 id from links order by newid()) a order by a.id desc select * from (select top 10 * from links order by newid()) order by id desc --我进来看下 MM,select * from(select top 10 * from links order by newid()) T order by id desc--然后就闪了. MM 就是分给得太少! : ) 多级分类如何取级? SQL Server外键级联删除时 触发器不能正常工作原因 問一個datediff進行時間排序的sql,不成功 高分求一sql语句 在表中建立聚簇索引.. 关联表之间的更新 菜鸟问题,CString对象的使用 求sql语句 解决? 在数据库 'tempdb' 中拒绝了 CREATE TABLE 权限。 用存储过程创建数据库,存在三个错误,请指正,谢谢 为什么我装SQL2005时老是说我的硬件配置低啊??急!!!高分求助!!
from (select top 10 id from links order by newid()) a
order by a.id desc
select * from
(
select top 10 * from links order by newid()
) T
order by id desc--然后就闪了. MM 就是分给得太少! : )