random ? --- 用这个 select top 10 * from ta order by newid()
select top 10 * from ta order by newid()
select * from ( select row_number() over(order by 字段)rowid,* from 表 )tb where rowid between 501 and 600 --取任意位置任意多个
select top 10 * from ta order by newid()
2 应该使用order by newid()
row_number()返回行号,对数据量超大的最好别用
1对的。 2、select top 10 * from ta order by newid()
1. select top 10 from....//取出前10个 select top 10 要排列的字段 from 表 order by 要排列的字段 desc 2. select random 10 from //取出任意10个 select top 10 * from 表 order by newid()
1. select top 10 from....//取出前10个 select top 10 * from tb order by id2. select random 10 from //取出任意10个 select top 10 * from tb order by newid()
---
用这个
select top 10 * from ta order by newid()
select row_number() over(order by 字段)rowid,* from 表
)tb where rowid between 501 and 600
--取任意位置任意多个
2、select top 10 * from ta order by newid()
select top 10 要排列的字段 from 表 order by 要排列的字段 desc
2. select random 10 from //取出任意10个
select top 10 * from 表 order by newid()
1. select top 10 from....//取出前10个
select top 10 * from tb
order by id2. select random 10 from //取出任意10个 select top 10 * from tb
order by newid()