All for Joomla All for Webmasters

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:

  1. SELECT column FROM table
  2. ORDER BY RAND ( )
  3. LIMIT 1

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

  1. SELECT TOP 1 column FROM table
  2. ORDER BY NEW ID()

If you want to select a random record with ORACLE:

  1. SELECT column FROM
  2. (SELECT column FROM table
  3. ORDER BY dbms_random.value)
  4. WHERE rownum =1

If you want to select a random row with PostgreSQL:

  1. SELECT column FROM table
  2. ORDER BY RAND()
  3. LIMIT 1
PinIt
submit to reddit

Leave a Reply

Top