laziness, impatience, and hubris | |
PerlMonks |
Re: Help with manipulating data from a database??by archfool (Monk) |
on Jul 02, 2007 at 13:55 UTC ( [id://624447]=note: print w/replies, xml ) | Need Help?? |
Two SQL queries.
I'm sure some SQL guru can wrap this all into one SQL query. In Oracle, you could use PL/SQL to get this, too. But even in pure SQL you should be able to do this without a loop. I'm just not an SQL guru. :(
In Section
Seekers of Perl Wisdom
|
|