Help with grouping queries in mySQL

Can someone tell me where the GROUP BY clause gets added to in the mysql query.

I am never sure with this one where it goes whether it is before or after an order by clause?

Also what is the DISTINCT query, is this the same or something different?

Re : Help with grouping queries in mySQL

Hi there

The grouping can be quite tricky, particularly as the queries get more and more complicated.

Basically it should go before the order by clause. The distinct query returns unique values rather than grouping values.

Re : Help with grouping queries in mySQL

Ok thanks for that... in the meantime I managed to get someone to explain to me the various different types of clause and so on with mysql and when to use GROUP BY and how it relates to other ways of collating data.

I also found about the HAVING clause rather than WHERE too so that was also interesting as I didn't even know there was a HAVING clause!