Hi everyone,

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

"elodie" <elodie.gillain (AT) gmail (DOT) com> a écrit dans le message de news:
d16e6671-ec5c-417c-af18-89721b386dc9...oglegroups.com...
MINUS

Regards
Michel

On 2011-10-17 04:39, elodie wrote:
I think that Oracle uses MINUS instead of EXCEPT (as Michel pointed
out). Another possibility:

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


/Lennart