in reply to Re: (Class::DBI Oracle SQL) rownum and group by woes
in thread (Class::DBI Oracle SQL) rownum and group by woes

Brilliant! Simply Brilliant! That didn't even cross my mind to put that in the having clause, and great explination on how where works before group by and having works after. I did not know that :-)

So far I've asked 2 questions here on PerlMonks and got 2 great answers!

PerlMonks++ and socketdave++

  • Comment on Re^2: (Class::DBI Oracle SQL) rownum and group by woes

Replies are listed 'Best First'.
Re^3: (Class::DBI Oracle SQL) rownum and group by woes
by socketdave (Curate) on Jul 15, 2005 at 18:15 UTC
    Glad I could help... I had to think about this one for a minute. I'm hopelessly addicted to 'limit' in MySQL.