Select a random row with MySQL:
SELECT column FROM table ORDER BY RAND() LIMIT 1
Select a random row with PostgreSQL:
SELECT column FROM table ORDER BY RANDOM() LIMIT 1
Select a random row with Microsoft SQL Server:
SELECT TOP 1 column FROM table ORDER BY NEWID()
Select a random row with IBM DB2
SELECT column, RAND() as IDX FROM table ORDER BY IDX FETCH FIRST 1 ROWS onLY
Select a random record with Oracle:
SELECT column FROM ( SELECT column FROM table ORDER BY dbms_random.value ) WHERE rownum = 1
'나 어제 배웠다 > Database' 카테고리의 다른 글
DB2 MERGE 사용하기 (0) | 2013.07.17 |
---|---|
DB2 Byte 문자열 자르기(한글) (0) | 2013.05.23 |
with 구문 샘플 (0) | 2010.12.15 |
MS SQL Server 날짜계산 (0) | 2010.09.02 |
개발자를 위한 DBMS 3종 기능 비교 (0) | 2009.03.26 |