SQL SELECT RANDOM

The SQL SELECT RANDOM() function returns the random row. It can be used in online exam to display the random questions.

There are a lot of ways to select a random record or row from a database table. Each database server needs different SQL syntax.

If you want to select a random row with MY SQL:

SELECT column FROM table  

ORDER BY RAND ( )   

LIMIT 1  

If you want to select a random row with Microsoft SQL server:

SELECT TOP 1 column FROM table  

ORDER BY NEW ID() 

If you want to select a random record with ORACLE:

SELECT column FROM  

(SELECT column FROM table  

ORDER BY dbms_random.value)   

WHERE rownum =1  

If you want to select a random row with PostgreSQL


SELECT column FROM table  

ORDER BY RAND()   

LIMIT 1