方法一
select * from tbl
order by checksum(rand()*class), checksum(rand(),name)
方法二
select * from tbl
order by checksum(rand()*class), newid()
注:checksum(rand()*class) 这个要求class必须是数字,要是非数字值,就不行了
SQL语句,关于随机分组后在随机排序
最新推荐文章于 2023-12-18 19:15:37 发布
方法一
select * from tbl
order by checksum(rand()*class), checksum(rand(),name)
方法二
select * from tbl
order by checksum(rand()*class), newid()
注:checksum(rand()*class) 这个要求class必须是数字,要是非数字值,就不行了