SELECT RANDOM statement used to fetch random rows from existing table. SELECT RANDOM statement have different syntaxes for different database are listed below.

SELECT column FROM table
ORDER BY RAND() LIMIT limit_number; 

SELECT TOP 1 column FROM Table_name
ORDER BY NEW ID(); 

 SELECT column FROM 
(SELECT column FROM table 
ORDER BY dbms_random.value) 
WHERE rownum = row_number; 

SELECT column FROM table
ORDER BY RANDOM() LIMIT limit_number; 

SELECT column FROM table
ORDER BY RANDOM() LIMIT limit_number; 

• SELECT RANDOM used to provide random captcha while we want to log-in in an application.
• SELECT RANDOM used in Online Exams of students to appear random questions.
• SELECT RANDOM used in Web pages that to appear random pictures.
• SELECT RANDOM used to provide security in Some applications.

Let us consider below table(s) as an example table(s) to frame the SQL query for getting the desired results.

Scenario – Fetch 5 random rows from table.

Requirement – Fetch 5 random rows from employee_details table. The query was as follows –

SELECT * FROM employee_details ORDER BY RAND() LIMIT 5; 

By executing above query, we can get output like as shown in below –