dbms data random select1

• 

  DBMS별 데이터 랜덤 셀렉트 MySQL: SELECT column FROM table ORDER BY RAND() LIMIT 1 PostgreSQL: SELECT column FROM table ORDER BY RANDOM() LIMIT 1 Microsoft SQL Server: SELECT TOP 1 column FROM table ORDER BY NEWID() IBM DB2: SELECT column FROM table ORDER BY RAND() FETCH FIRST 1 ROWS ONLY Oracle: SELECT column FROM ( SELECT column FROM table ORDER BY dbms_random.value ) WHERE rownum = 1 OR select hotel_number from( select.. DB 2017. 9. 21.