Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Site Related Forums
 Article Discussion
 Article: How to Use GROUP BY with Distinct Aggregates and Derived tables

Author  Topic 

Ask SQLTeam Question

0 Posts

Posted - 2007-07-31 : 09:09:08

In How to Use GROUP BY, we worked on a simple report request and covered the basics of GROUP
and the issue of duplicate rows caused by JOINs. Today we'll finish
up that report while examining SUM(Distinct), and see just
how crucial derived tables are when summarizing
data from multiple tables.

Read How to Use GROUP BY with Distinct Aggregates and Derived tables

Constraint Violating Yak Guru

282 Posts

Posted - 2007-09-01 : 05:51:35
Thanks Jeff for the wonderful article. You not only helped in understanding derived tables but also showed how one should approach writing a query - one step at a time. Eagerly waiting for your next article.
Go to Top of Page

Starting Member

1 Post

Posted - 2007-12-09 : 17:07:26
Thank you very much for this so demonstrative article!

"The virtual primary key of a SELECT with a GROUP BY clause will always be the expressions stated in the GROUP BY."
I've never thought about grouped Resultsets this way. It's so much clearer now. :)
Go to Top of Page

Starting Member

1 Post

Posted - 2008-09-07 : 11:30:51
Wowww, great article... It really helped...
Go to Top of Page

Starting Member

1 Post

Posted - 2009-02-02 : 01:35:39
Wonderful article!!! Clearly demonstrates the concept behind join result sets, GROUP By scenario and derived table usage. This should be the norm/way to explain fundamental concepts.

Thank you so much, Jeff. Hats-off!!

Go to Top of Page

Starting Member

1 Post

Posted - 2013-10-02 : 11:17:47
will a question still be answered here?
Go to Top of Page

- Advertisement -