서비의 다락방

뒤로 검색

DBMS별 데이타 랜덤 셀렉트하기 :: Random Row Select

2008/02/17 16:45

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

Tags

dbms, query, sql
이 페이지는 Textcube 1.10.9 : Tempo primo 로 구동됩니다 데스크탑 화면