Re: (Class::DBI Oracle SQL) rownum and group by woes

[socketdave]

Tyraziel, try this:

select sum(t.amount) as total, a.id, t.id from accounts a, transactions t where a.id = t.id group by (a.id, t.id) having rownum < ?

Where works before 'group by' and having works after.

[Tyraziel]

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++

[socketdave]

Glad I could help... I had to think about this one for a minute. I'm hopelessly addicted to 'limit' in MySQL.