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