Exclude Rows based on overlapping restrictions (SQL)

Question

I was looking at this link, but was still having trouble creating my statement. I have the following query

SELECT SUM(AMT) AS TOTAL, NAME, YEAR 
FROM TABLE WHERE IND='ISVALID' GROUP BY NAME, YEAR

I would get the following results

TOTAL | NAME | YEAR 
====================
10000 | JOHN | 2010  
20500 | PETE | 2009 
12500 | MIKE | 2008 
50500 | MARY | 2008 
50500 | MARY | 2007 
40000 | JANE | 2007

I would like to exclude 50500 | MARY | 2008, which has an IND column with 'ISVALID' as well. How do I do this?

@simchona - The criteria is an indicator which returns all that data, but 50500 mary 2008 is a false positive. — MrM, Feb 08 '12 at 19:41

score 3 · Accepted Answer · answered Feb 08 '12 at 19:42

3

SELECT SUM(AMT) AS TOTAL, NAME, YEAR 
FROM TABLE 
WHERE IND='ISVALID' AND (NAME <> 'MARY' OR YEAR <> 2008)
GROUP BY NAME, YEAR

answered Feb 08 '12 at 19:42

Michael Fredrickson

36,839
5
92
109

Exclude Rows based on overlapping restrictions (SQL)

1 Answers1