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 -> Re: SQL query help

Re: SQL query help

From: Al Reid <areidjr_at_reidDASHhome.com>
Date: Wed, 23 Aug 2006 14:15:41 -0400
Message-ID: <12ep71uet0q1c76@corp.supernews.com>


Al Reid wrote:
>
> Perhaps if you move the ORDER BY to the outer SELECT it will return
> the records in the order you want.
>
> SELECT distinct * from (SELECT
> Client_Structure_Version.CLIENT_STRUCTURE_ID, FIELD_NAME,
> FIELD_TYPE, FIELD_WIDTH, FIELD_ORDER
> FROM Client_Structure_Version)
> ORDER BY client_structure_record_id,FIELD_ORDER;

Actually, I think it should have been

 SELECT distinct * from (SELECT
   Client_Structure_Version.CLIENT_STRUCTURE_ID, FIELD_NAME,     FIELD_TYPE, FIELD_WIDTH, FIELD_ORDER     FROM Client_Structure_Version)
 ORDER BY FIELD_ORDER;

-- 
Al Reid

"It ain't what you don't know that gets you into trouble. It's what you
know for sure that just ain't so."  --- Mark Twain
Received on Wed Aug 23 2006 - 13:15:41 CDT

Original text of this message

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