SELECT month, year, MAX(nsick) FROM sick GROUP BY month, year having not between MIN(nsick) and MAX(nsick) .
Hope this will wrok... Regards, Jignesh Makwana, +919892500936 On Mon, Oct 17, 2011 at 8:04 AM, elodie <[email protected]> wrote: > 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 > > -- > You received this message because you are subscribed to the Google > Groups "Oracle PL/SQL" group. > To post to this group, send email to [email protected] > To unsubscribe from this group, send email to > [email protected] > For more options, visit this group at > http://groups.google.com/group/Oracle-PLSQL?hl=en > -- You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en
