Difference between revisions of "Plsql first records"

Latest revision as of 11:28, 3 October 2023

To fetch the first 10 records from a result.

 SELECT *
 FROM table_a
 FETCH FIRST 1 ROW ONLY;