bitscn.com
各个数据库获取随机列的语法
[html]
各个数据库获取随机列的语法
mysql
select column from table order by rand() limit 10
oracle
select column from( select column from table order by dbms_random.value ) where rownum
postgresql
select column from table order by random() limit 10
sql server
select top 10 column from table order by newid()
bitscn.com