Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Tricky query
I got a query I am trying to compose. Its complex to me!
I need to create a query where three oldest records with like ky_premise_no is sorted by order_completion date
The DTE and TME (Don't ask why the developers didn't use DATE) will be used to determine the age. The ky_premise_no can be duplicates per unique source_order_nbr. The query would only pull back the three oldest duplicate ky_prem_no and order by order_completion_date.