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

Next TopicSQL Select As

<<prev next>>

Latest Courses

We provides tutorials and interview questions of all technology like java tutorial, android, java frameworks

Contact info

G-13, 2nd Floor, Sec-3, Noida, UP, 201301, India

[email protected].

Python

AI, ML and Data Science

Java

B.Tech and MCA

Web Technology

Software Testing

Technical Interview

Java Interview

Web Interview

Database Interview

Company Interviews

SQL Tutorial

SQL Database

SQL Table

SQL Select

SQL Clause

SQL Order By

SQL Insert

SQL Update

SQL Delete

SQL Join

SQL Keys

Difference

SQL Injection

SQL String Functions

Misc

SQL MCQ

PL/SQL Tutorial

Interview

Quiz

SQL SELECT RANDOM

Latest Courses

Contact info

Follow us

Tutorials

Interview Questions

Online Compiler