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

Question

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

Answer 1

比如随机插4条oracleselect * from (select * from 表名 order by dbms_random.value) where rownum<=4sqlserverselect top 4 * from 表名 order by newid()mysqlselect * from 表名 order by rand() limit 4;