'개수'에 해당되는 글 2건

출처 : http://mboy.tistory.com/49

MySQL
SELECT column FROM table ORDER BY RAND() LIMIT 1


PostgreSQL
SELECT column FROM table ORDER BY RANDOM() LIMIT 1


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


Microsoft SQL Server
SELECT TOP 1 column FROM table ORDER BY NEWID()
블로그 이미지

fallacy.kr SG's Life

댓글을 달아 주세요

출처 : http://mboy.tistory.com/49

MySQL
SELECT column FROM table ORDER BY RAND() LIMIT 1


PostgreSQL
SELECT column FROM table ORDER BY RANDOM() LIMIT 1


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


Microsoft SQL Server
SELECT TOP 1 column FROM table ORDER BY NEWID()
블로그 이미지

fallacy.kr SG's Life

댓글을 달아 주세요