Hi Sam

I don’t know what the case you need this to, but anyway you can use the following query to get random row from employees table as an example. 1- Oracle :

SELECT *
FROM (SELECT *
FROM EMPLOYEES
ORDER BY DBMS_RANDOM.VALUE)
WHERE ROWNUM = 1

2- MySQL :

SELECT column FROM table
ORDER BY RAND()
LIMIT 1

The idea here in both examples is to get all rows in employees table but in random orders then using ROWNUM in Oracle and LIMIT clause in MySQL to return one row from them.