Re: GROUP BY behaving strangely
Posted by:
Bennet Eze
Date: April 17, 2019 01:24PM
Thanks for your reply.
Only the columns specified in the GROUP BY clause are used to determine duplicate records. I thought that DISTINCT will use all columns to determine duplicates which will be wrong in this example. If I am wrong please correct me.
Subject
Written By
Posted
Re: GROUP BY behaving strangely
April 17, 2019 01:24PM
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.