数据库随机查询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;