Random(2)
-
DATABASE별 결과 값 RANDOM 으로 나오게 하기
ORACLE SELECT * FROM TABLE_NAME SAMPLE (3)SELECT * FROM (SELECT * FROM TABLE_NAME ORDER BY DBMS_RANDOM.VALUE)WHERE ROWNUM < 3 MSSQLSELECT TOP 3 * FROM TABLE_NAME ORDER BY NEWID() MYSQLSELECT * FROM TABLE_NAME ORDER BY RAND() LIMIT 0,3
2015.04.23 -
DATABASE별 결과 값 RANDOM 으로 나오게 하기
ORACLE SELECT * FROM TABLE_NAME SAMPLE (3) SELECT * FROM ( SELECT * FROM TABLE_NAME ORDER BY DBMS_RANDOM.VALUE ) WHERE ROWNUM < 3 MSSQL SELECT TOP 3 * FROM TABLE_NAME ORDER BY NEWID() MYSQL SELECT * FROM TABLE_NAME ORDER BY RAND() LIMIT 0,3
2013.10.08