MySQL: SELECT * FROM Table_Name ORDER BY RAND() LIMIT 6;
SQL Server: SELECT TOP 6 * FROM Table_Name ORDER BY NEWID();
Oracle:SELECT * FROM (SELECT * FROM Table_Name ORDER BY DBMS_RANDOM.RANDOM()) WHERE Rownum <= 6;
MySQL: SELECT * FROM Table_Name ORDER BY RAND() LIMIT 6;
SQL Server: SELECT TOP 6 * FROM Table_Name ORDER BY NEWID();
Oracle:SELECT * FROM (SELECT * FROM Table_Name ORDER BY DBMS_RANDOM.RANDOM()) WHERE Rownum <= 6;