Randomly select rows from sql

3 ANSWERS

1. Vigorian
   

   There are lots of ways to select a random record or row from a database table. Here are some example SQL statements that don't require additional application logic, but each database server requires different SQL syntax SELECT column FROM table ORDER BY RAND() SELECT column FROM table ORDER BY RANDOM() LIMIT 1

   Report (0) (0)  |   2 years, 11 month(s) ago  

2. awaisj
   

   NEWID() is MS SQL specific. For MS Access use: SELECT TOP 1 Field1 , ..., FieldN FROM Table1 ORDER BY Rnd(Field1) For MySQL use: SELECT Field1, ..., FieldN FROM Table1 ORDER BY RAND() LIMIT 1 For Oracle use: SELECT Field1, ..., FieldN FROM ( SELECT Field1, …, FieldN FROM Table1 ORDER BY dbms_random.value) WHERE rownum <= 1 For SQL Lite use: SELECT Field1, ..., Field2 FROM Table1 ORDER BY Random() LIMIT 1 For DB2 use: SELECT Field1, ..., FieldN, RAND() as RID FROM Table1 ORDER BY RID FETCH FIRST 1 ROWS ONLY For PostgreSQL use: SELECT "Field1", "...", "FieldN" FROM "Table1" ORDER BY RANDOM() LIMIT 1

   Report (0) (0)  |   2 years, 11 month(s) ago  

3. Guest358706
   

   SELECT TOP 5 column FROM table ORDER BY NEWID()

   Report (0) (0)  |   2 years, 11 month(s) ago