Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag GROUP BY Rss

   Items 1 to 7 of 7   
 

Using SQL Server's GROUP BY clause to Summarize your Data

SQL Server’s GROUP BY clause provides you a way to aggregate your SQL Server data and to group data on a single column, multiple columns, or even expressions. Greg Larsen discusses how to use the GROUP by clause to summarize your data.  Read more...
By Additional Articles 2015/02/11 | Source: Database Journal | Category: group by
Rating:  Rate this |   Briefcase | 9,703 reads

Group By, Count, and NULLs

By Justin Clementz 2015/02/02 | Category: count
Rating: (not yet rated) |  Discuss |   Briefcase | 2,008 reads

Find Customers Who Bought "A" and "B" But Not "C" (SQL Spackle)

A simple problem that can become complex in T-SQL. How do you find the rows that match 2 conditions, but not a third, in an efficient manner. MVP Jeff Moden gives us a solution.  Read more...
By Jeff Moden 2014/06/06 (first published: 2012/03/29) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 22,018 reads

Find Customers Who Bought "A" and "B" But Not "C" (SQL Spackle)

A simple problem that can become complex in T-SQL. How do you find the rows that match 2 conditions, but not a third, in an efficient manner. MVP Jeff Moden gives us a solution.  Read more...
By Jeff Moden 2014/06/06 (first published: 2012/03/29) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 22,018 reads

Group by

By Manie Verster 2010/09/06 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 3,961 reads

group by

By VM-723206 2009/08/31 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 4,778 reads

Limit Groups by Number Using Transact-SQL or MS Access

You can easily limit or group a recordset, but doing both to the same recordset takes a bit of hand coding. Find out how both SQL Server and MS Access can handle the task.  Read more...
By Additional Articles 2009/07/07 | Source: DevX | Category: t-sql
Rating: (not yet rated)  Rate this |   Briefcase | 1,940 reads
   Items 1 to 7 of 7   
 
Tags
t-sql (5)    
count (1)    
except (1)    
having (1)    
null (1)    
subquery (1)