[Conny Westh]

Om du kör någon relationsdatabas med SQL så kan du använda följande SQL-sats för att visa 10 produkter i slumpartad ordning:

MySQL:

SELECT column_names
FROM tbl_name 
ORDER BY RAND() LIMIT 10;

sql-server:

SELECT TOP 10 column_names
FROM tbl_name 
ORDER BY NewID()

MS Access (Kräver en numerisk kolumn att arbeta med):

SELECT TOP 10 column_names
FROM tbl_name
ORDER BY rnd(numericalfield)

PostgreSQL:

SELECT column_names FROM tbl_name
ORDER BY RANDOM()
LIMIT 10

IBM DB2:

SELECT column_names, RAND() as IDX 
FROM tbl_name 
ORDER BY IDX FETCH FIRST 10 ROWS ONLY

Oracle:

SELECT column_names 
FROM 
 * * * *( SELECT column_name FROM table
 * * * * *ORDER BY dbms_random.value 
 * * * *)
WHERE rownum <= 10