Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Tricky query
James Williams wrote:
> 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.
>
> ----------------------------------------- --------
> ----------------------------
> SOURCE_ORDER_NBR NOT NULL VARCHAR2(30)
> KY_PREM_NO NOT NULL NUMBER(38)
> DTE VARCHAR2(8)
> TIME VARCHAR2(6)
> DESTINATION_APP_ID VARCHAR2(4)
> RECORD_TYPE VARCHAR2(1)
> RECORD_SUB_TYPE VARCHAR2(1)
> RECORD_FUNCTION VARCHAR2(1)
> RECORD_SEQUENCE_NBR VARCHAR2(2)
> WORK_GROUP_ID VARCHAR2(9)
> WORK_ORDER_NBR VARCHAR2(6)
> ORDER_COMPLETION_DTE VARCHAR2(8)
> ORDER_TYPE VARCHAR2(6)
> ACTION_TAKEN VARCHAR2(12)
> EMPLOYEE_ID VARCHAR2(8)
> COMMENTS VARCHAR2(255)
> LAST_PAY_AMOUNT NUMBER(12,2)
> LAST_PAY_DTE VARCHAR2(8)
> BALANCE_DUE NUMBER(11,2)
> DUE_DTE VARCHAR2(8)
> DELINQUENT_AMOUNT NUMBER(11,2)
> NBR_OF_CUTOFFS NUMBER(5)
> CREDIT_INFO VARCHAR2(12)
Have you looked at ORDER BY?
Daniel A. Morgan Received on Wed May 30 2001 - 01:07:50 CDT