Oracle select top 10
In this post , I am sharing the sql query to find and Extract the top 10 values of the Oracle Tables. With the help of this sql query , we can easily find the top 10 values of the table. We often have an requirment in oracle apps to get the top 10 invoice amounts or to find the top 10 oracle payments so with the help of this sql query we can easily fullfillls this requirment.
Here in the below example i am trying to fin the top 10 Invoice amounts in Oracle Database.
SELECT INVOICE_NUM,INVOICE_AMOUNT FROM (
SELECT INVOICE_NUM,INVOICE_AMOUNT FROM AP_INVOICES_ALL
ORDER BY INVOICE_AMOUNT DESC)
WHERE ROWNUM<=10
0 comments:
Post a Comment