use of except

From: elodie <elodie.gillain_at_gmail.com>
Date: Sun, 16 Oct 2011 19:39:35 -0700 (PDT)
Message-ID: <d16e6671-ec5c-417c-af18-89721b386dc9_at_ff5g2000vbb.googlegroups.com>



[Quoted] Hi everyone,

[Quoted] I would appreciate if someone could help me fix the following sql query.

The goal of the query is to find those years and months where a total is either less than 50 or more than 100.

SELECT month, year, MAX(nsick)
FROM sick
GROUP BY month, year
EXCEPT
SELECT month, year, MAX(nsick)
FROM sick
GROUP BY month, year
HAVING MAX(nsick)>50 AND MAX(nsick)<100;

I get the following error message:
EXCEPT
*
ERROR at line 4:
ORA-00933: SQL command not properly ended

Thanks in advance Received on Mon Oct 17 2011 - 04:39:35 CEST

Original text of this message