SQLServerCentral.com Content tagged T-SQL, GROUP BY

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

Thu, 29 Mar 2012 06:00:00 UT

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.

Group by

Mon, 06 Sep 2010 06:00:00 UT

group by

Mon, 31 Aug 2009 06:00:00 UT

Make working with SQL a breeze
SQL Prompt 5 is the effortless way to write, edit, and explore SQL. It's packed with features such as code completion, script summaries, and SQL reformatting, that make working with SQL a breeze. Try it now.

Limit Groups by Number Using Transact-SQL or MS Access

Tue, 07 Jul 2009 06:00:00 UT

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.