oracle:select * from (select * from test_table order by dbms_random.random()) where rownum <=10
MySQL: SELECT * FROM T_USER ORDER BY RAND() LIMIT 10
SQL Server: SELECT TOP 10 * FROM T_USER ORDER BY NEWID()
oracle:select * from (select * from test_table order by dbms_random.random()) where rownum <=10
MySQL: SELECT * FROM T_USER ORDER BY RAND() LIMIT 10
SQL Server: SELECT TOP 10 * FROM T_USER ORDER BY NEWID()