From: "Taylor, Chris David" <ChrisDavid.Taylor@ingrambarge.com>
To: "'oracle-l@freelists.org'" <oracle-l@freelists.org>
Date: Thu, 28 Jun 2012 21:35:29 -0500
Subject: someone double-check me on this sql
Thread-Topic: someone double-check me on this sql
Message-ID: <C5533BD628A9524496D63801704AE56D75B2BA0321@SPOBMEXC14.adprod.directory>
Accept-Language: en-US
Content-Language: en-US
acceptlanguage: en-US
Content-type: text/plain
MIME-Version: 1.0
Content-Transfer-Encoding: 8bit
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
Precedence: normal
Reply-To: ChrisDavid.Taylor@ingrambarge.com

I'm  a bit fuzzy at the moment due to pain meds after a minor surgery so I'm hoping someone can spot my error (if I have an error)

Table has months, years and 'x' number of rows for each

The table has Years 2011 and 2012
In 2011, it has months 1-12
And in 2012 it has months 1-5

I run this:
Select month, year, count(*) -- month, and year are actual column names
From some_table
Where (month != 5 and year != 2012)
Group by month, year
/

The data set I get is Months 6-12 for 2011 *ONLY*

Shouldn't that query *ONLY* exclude MONTH=5 and YEAR 12 together?  (instead of ALL 2012 and ALL 5s?)


Chris Taylor

"Quality is never an accident; it is always the result of intelligent effort."
-- John Ruskin (English Writer 1819-1900)

Any views and/or opinions expressed herein are my own and do not necessarily reflect the views of Ingram Industries, its affiliates, its subsidiaries or its employees.


--
http://www.freelists.org/webpage/oracle-l