Access:
select top n * from table order by rnd(id)
Sql Server:
select top n * from table order by newid()
MySql:
select * from table order by rand() limit 20;
Oracle:
select * from table order by dbms_random.value()
Access:
select top n * from table order by rnd(id)
Sql Server:
select top n * from table order by newid()
MySql:
select * from table order by rand() limit 20;
Oracle: