MySQL Forums
Forum List  »  PHP

Advanced Search
New Topic

Re: Trying to do Inner Join, plus DISTINCT on a column
Posted by: Peter Brawley
Date: November 13, 2019 09:25AM

Please read the manual Group By page---Group By without an aggregating function would return reproducible Distinct row only whn Grouping By all rows listed in the Select list.

By "Distinct rows based on topicid" do you mean distinct for all columns in the query, or all values of topicid?

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
Trying to do Inner Join, plus DISTINCT on a column
Simon Lewis
November 12, 2019 10:09AM
Re: Trying to do Inner Join, plus DISTINCT on a column
Peter Brawley
November 12, 2019 12:00PM
Re: Trying to do Inner Join, plus DISTINCT on a column
Simon Lewis
November 13, 2019 04:16AM
Re: Trying to do Inner Join, plus DISTINCT on a column
Peter Brawley
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.