Want to Pull "x" number of records.

[cocheese]

Hi. I'm working in Oracle SQL and i want to view the details on just 20 random records from a table. What's the proper syntax for this?

[Saii]

See if this helps

SELECT *
FROM (SELECT *
FROM <table_name>
ORDER BY DBMS_RANDOM.ran dom ())
WHERE ROWNUM <= 20;