To limit the number of rows returned by an Oracle query after ordering, you can use the "FETCH FIRST" clause in your query. This clause specifies the number of rows that should be returned from the result set after sorting. Here's an example query:
SELECT column1, column2, column3 FROM your_table ORDER BY column1 FETCH FIRST 10 ROWS ONLY;
In this example, the query will return the first 10 rows of the result set after sorting by "column1". You can adjust the number of rows returned by changing the number after the "FETCH FIRST" clause.
Post a Comment