SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 Site Related Forums
 Article Discussion
 Article: How to Use GROUP BY with Distinct Aggregates and Derived tables		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

AskSQLTeam
Ask SQLTeam Question

USA
0 Posts
Posted - 07/31/2007 :  09:09:08  Show Profile  Visit AskSQLTeam's Homepage  Reply with Quote

In How to Use GROUP BY, we worked on a simple report request and covered the basics of GROUP
BY 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

sunil
Constraint Violating Yak Guru

India
282 Posts
Posted - 09/01/2007 :  05:51:35  Show Profile  Reply with Quote
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

binor
Starting Member

1 Posts
Posted - 12/09/2007 :  17:07:26  Show Profile  Reply with Quote
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

mehrandvd
Starting Member

Iran
1 Posts
Posted - 09/07/2008 :  11:30:51  Show Profile  Visit mehrandvd's Homepage  Reply with Quote
Wowww, great article... It really helped...
Thanks...
Go to Top of Page

kkebero
Starting Member

1 Posts
Posted - 02/02/2009 :  01:35:39  Show Profile  Reply with Quote
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
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000