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

SQL Tutorial