MySQL Forums
Forum List  »  Newbie

"group by" subquery distinct
Posted by: michael marth
Date: August 29, 2004 07:05AM

is it possible to have a distinct modifier for "group by"

such as :

group by(distinct)

SELECT sum(price) AS totArt from ArtSale where artist=$artist GROUP BY (distinct left(artId,2) from ArtSale)

Options: ReplyQuote

Written By
"group by" subquery distinct
August 29, 2004 07:05AM

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.