Thank you for correcting my typo. The main point for the OP to remember is that they should think of HAVING in the same sense for group expressions as WHERE is for ordinary ones.
On Jun 25, 1:49 am, "faizal mangattil`" <faizmangat...@gmail.com> wrote: > do like this > > select column1, count(*) from table1 group by column1 having count(column1) > > > 99; > On Wed, Jun 24, 2009 at 3:24 PM, Pav <ksulta...@googlemail.com> wrote: > > > Hi > > > I was trying to run an sql statement as following > > > select column1, count(*) from table1 group by column1 where count > > (column1) > 99; > > > This seems to be incorrect, and so I was wondering if anyone knew a > > working alternative? > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to Oracle-PLSQL@googlegroups.com To unsubscribe from this group, send email to oracle-plsql-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en -~----------~----~----~----~------~----~------~--~---
