The secret to retrieve random rows from database is really simple. Here are some example SQL statements that do not require additional application logic.SQL Server:SELECT TOP 1 *FROM UsersORDER BY NEWID()MySQL:SELECT * FROM UsersORDER BY RAND()LIMIT 1;Oracle:SELECT * FROM(SELECT * FROM UsersORDER BY dbms_random.value )WHERE rownum = 1PostgreSQL:SELECT * FROM UsersORDER BY RANDOM()LIMIT 1Access:SELECT TOP 1 *FROM UsersORDER BY Rnd(UserID)Chee...
Tuesday, December 29, 2009
Generate random rows with SQL
Author: xiaoyu
| Posted at: 3:59 PM |
Filed Under:
ms access,
my sql,
oracle,
sql server
Subscribe to:
Posts (Atom)