查询数据库中的任意一条语句sql、 random

来源:互联网 发布:张艺兴发布会知乎 编辑:程序博客网 时间:2024/06/13 00:15

关于取数据库中的任意一条语句的总结:

MySQL:

select * from table order by rand() limit 1


PostgreSQL:

select * from table order by random() limit 1


Microsoft SQL Server:

select  top 1 colimn from table order by newid()


IBM DB2:

select column,rand() as cd from table order by cd fetch first 1 rows only


Oracle:

select column from (select column from table order by dbms_random.value) where rownum=1



0 0