SQLServerCentral: Articles tagged GROUP BY

Items 1 to 2 of 2

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 2012/03/29 | Source: SQLServerCentral.com | Category: t-sql

Rating:

Discuss |

Briefcase | 13,204 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,835 reads

Items 1 to 2 of 2

Articles with tag GROUP BY

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

Limit Groups by Number Using Transact-SQL or MS Access