Thread: Selecting Random Row from Database

Select a random row with Microsoft SQL Server:
SELECT TOP 1 column FROM table
ORDER BY NEWID()


Select a random row with MySQL:
SELECT column FROM table
ORDER BY RAND()
LIMIT 1


Select a random row with PostgreSQL:
SELECT column FROM table
ORDER BY RANDOM()
LIMIT 1


Select a random row with IBM DB2
SELECT column, RAND() as IDX
FROM table
ORDER BY IDX FETCH FIRST 1 ROWS ONLY


Select a random record with Oracle:
SELECT column FROM
( SELECT column FROM table
ORDER BY dbms_random.value )
WHERE rownum = 1

Thanks manik ... the database article on webcosmo are really nice and useful

I also wanted know this...
I am really thankful to Manik...
I missed that class in college....

Hi friend.
Thanks for the code.
Its very useful.

Hi Manik,

Thanks for give this code its really use full for me.

Thanks and Nice Information

to select random row from database on should follow this code:

SELECT * FROM `table` ORDER BY RAND() LIMIT 0,1;