Oracle随机取出若干条记录的SQL语句

====Oracle随机抽取数据

SELECT * FROM (SELECT * FROM STUDENT_INFO ORDER BY DBMS_RANDOM.RANDOM() ) WHERE Rownum <= 10;

====MySql随机抽取数据

SELECT * FROM tablename ORDER BY RAND() LIMIT 10;