I want to run a query which sums up instances over a period and only return the top 5 occurances,
This is the code that shows all results.
select po.vendor_cd,supplier_nm,end_dt,
sum(1) as created_qty
from
ENG_NOTIFICATIONS nots left outer join eng_purchase_orders po on...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.