从数据库中随机读取几条数据

Oracle:

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

eg: select * from (select * from t_bd_person order by dbms_random.value) where rownum <= 5

MS SQLServer:

       select top N * from tableName order by newid()

 

My SQL:

       select * from tableName order by rand() limit N

eg:select * from t_bd_person order by rand() limit 5