본문 바로가기

나 어제 배웠다/Database

Random Select...

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