Cheap VPS & Xen Server


Residential Proxy Network - Hourly & Monthly Packages

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

Comments

comments