My SQL:
select * from a order by rand() limit 1
Oracle:
select * from (select * from table-name order by dbms_random.value) where rownum <= 5
SQLServer:
select top N * from tableName order by newid()
My SQL:
select * from a order by rand() limit 1
Oracle:
select * from (select * from table-name order by dbms_random.value) where rownum <= 5
SQLServer:
select top N * from tableName order by newid()