Return rows in random order

Question

Is it possible to write SQL query that returns table rows in random order every time the query run

User · Accepted Answer

SELECT   FROM table ORDER BY NEWID

User · Answer

SQL Server   MS Access Syntax   SELECT TOP 1   FROM table name ORDER BY RAND     MySQL Syntax    SELECT   FROM table name ORDER BY RAND   LIMIT 1

User · Answer

To be efficient  and random  it might be best to have two different queries   Something like     SELECT table id FROM table  Then  in your chosen language  pick a random id  then pull that row s data   SELECT   FROM table WHERE table id    rand id  But that s not really a good idea if you re expecting to have lots of rows in the table   It would be better if you put some kind of limit on what you randomly select from   For publications  maybe randomly pick from only items posted within the last year

User · Answer

Here s an example  source    SET  randomId   Cast    maxValue   1  -  minValue    Rand      minValue AS tinyint

User · Answer

The usual method is to use the NEWID   function  which generates a unique GUID  So   SELECT   FROM dbo Foo ORDER BY NEWID

User · Answer

This is the simplest solution   SELECT quote FROM quotes ORDER BY RAND      Although it is not the most efficient  This one is a better solution

[sql] Return rows in random order

Examples related to sql

Examples related to sql-server

Examples related to tsql