SQL、MySQL、Oracle随机查询语句？

Question

SQL、MySQL、Oracle随机查询语句？

Answer 1

比如随机插4条
oracle
select * from (select * from 表名 order by dbms_random.value) where rownum<=4

sqlserver
select top 4 * from 表名 order by newid()

mysql
select * from 表名 order by rand() limit 4;