从数据库表中随机获取N条记录的SQL语句

Oracle：

select * from (select * from tableName order by dbms_random.value) where rownum < N

select top N * from tableName order by newid()

select * from tableName order by rand() limit N