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()
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
(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
ORDER BY RAND()
LIMIT 1
