Tuesday, September 28, 2010

Randomly selecting a value from a table

SELECT *
 FROM (SELECT empname, dept, salary, managerid
         FROM emp

     ORDER BY DBMS_RANDOM.VALUE)
WHERE rownum <= 4;


sample output

empname dept salary managerid
x                 IT    50000 1001
y                IT     25603 1002
z                 IT    25489   1001

No comments:

Post a Comment