CodingForums.com - View Single Post

guelphdad · 06-26-2007, 06:56 PM

There is a lot of confusion on using the GROUP BY clause and specifically when it is and isn't okay to leave columns out of the GROUP BY clause.

A little heavy lifting here but this article is quite good for those looking to find out more information.

Unfortunately I see GROUP BY used incorrectly in a lot of forums.

06-26-2007, 06:56 PM	PM User \| #7
guelphdad Super Moderator Join Date: Mar 2006 Location: St. Catharines, Ontario Canada Posts: 2,629 Thanks: 4 Thanked 147 Times in 138 Posts	There is a lot of confusion on using the GROUP BY clause and specifically when it is and isn't okay to leave columns out of the GROUP BY clause. A little heavy lifting here but this article is quite good for those looking to find out more information. Unfortunately I see GROUP BY used incorrectly in a lot of forums.