2008/04/06 18:22

sql random 1개 row 출력 예시

2008/04/06 18:22 in [Database] ORACLE

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

Posted by 무소유v
Trackback 0 Comment 0
prev Prev 1 ... 139 140 141 142 143 144 145 146 147 ... 465 Next next