In Oracle 12c , new keyword has been added for Top-N queries.
below is the example:
SELECT * FROM all_objects ORDER BY object_name DESC FETCH FIRST 10 ROWS ONLY;
If you like dEexams.com and would like to contribute, you can write your article here or mail your article to admin@deexams.com . See your article appearing on the dEexams.com main page and help others to learn.
Search
Search
