Try it here
Subscribe
LIMIT on query result

Oracle 12C Top-N Feature

oracle_12c_top-n_feature

Top-N Feature

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;

Writer profile pic

Admin on Jan 17, 2019 at 12:01 am


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.



Post Comment

Comments( 0)

WEB TECHNOLOGY

Articles

×

Forgot Password

Please enter your email address below and we will send you information to change your password.