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

Comments

Leave a Reply

Your email address will not be published. Required fields are marked *