Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Tricky query

Tricky query

From: James Williams <techsup_at_mindspring.com>
Date: Tue, 29 May 2001 20:03:55 GMT
Message-ID: <3b13ff43.3550857@news.mindspring.com>

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.

Received on Tue May 29 2001 - 15:03:55 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US