Re: Sorting by data the lowest values
Posted by: Rick James
Date: June 03, 2010 09:05PM

The GROUP BY has to happen after the ORDER BY, so you need a subquery:
    SELECT  T1.*,
        FROM  T1
        JOIN  T2 ON
        WHERE'. $variable. '
        ORDER BY,, 
                 ) x
    GROUP BY  x.owner
    ORDER BY,, 

Options: ReplyQuote

Written By
Re: Sorting by data the lowest values
June 03, 2010 09:05PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.