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 8 of 8   
 

Using the ROLLUP, CUBE, and GROUPING SETS Operators

Greg Larsen discusses the ROLLUP, CUBE and GROUPING SETS operators. These operators are used with the GROUP BY clause and allow you to create subtotals, grand totals and superset of subtotals. Read on to find out more about these additional GROUP BY operators.  Read more...
By Additional Articles 2015/03/18 | Source: Database Journal | Category: group by
Rating: (not yet rated)  Rate this |   Briefcase | 10,603 reads

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 | 11,021 reads

Group By, Count, and NULLs

By Justin Clementz 2015/02/02 | Category: count
Rating: (not yet rated) |  Discuss |   Briefcase | 2,205 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,127 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,127 reads

Group by

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

group by

By VM-723206 2009/08/31 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 4,785 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,998 reads
   Items 1 to 8 of 8   
 
Tags
t-sql (5)    
count (1)    
except (1)    
having (1)    
null (1)    
subquery (1)