[MYSQL] 랜덤하게 select 하기

mysql 랜덤하게 5개불러오기

select * from table order by RAND() limit 5; 

oracle 랜덤하게 5개 불러오기

SELECT * FROM ( SELECT AA.*, ROWNUM SEQ_NO FROM (

select * from table order by DBMS_RANDOM.RANDOM

) AA WHERE ROWNUM <= 5) WHERE SEQ_NO >=  1 AND SEQ_NO <= 5

mssql 랜덤하게 5개 불러오기

select top 5 * from table order by newid();

tmax 랜덤하게 불러오기

select * from tb_cm_pagecharge order by dbms_random.value;

SELECT *

FROM

(

  SELECT * FROM table

  ORDER BY dbms_random.value

)

WHERE rownum <= 5

[출처] [Oracle] 오라클 쿼리 결과 랜덤으로 가져오기|작성자 so