Re: Trying to do Inner Join, plus DISTINCT on a column
With Group By, all Select columns that neither aggregate nor are Grouped By return arbitrary results, so your query as written returns unreliable results.
By "distinct row" you mean what, specifically when there are multiple message rows for one id, what do you want the query result to look like?
Subject
Written By
Posted
November 12, 2019 10:09AM
Re: Trying to do Inner Join, plus DISTINCT on a column
November 12, 2019 12:00PM
November 13, 2019 04:16AM
November 13, 2019 09:25AM
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.