![]() |
|
Well, that's me after several weeks of non-shaving :-)
-----BEGIN PERL GEEK CODE BLOCK----- Version: 0.01 P+++>++++(+++)$c-->+P6+ R++>++++M++>+++O++>+++MA++E++PU+BD C++D++>+++S++X+WP+++MO+PP!n-CO PO o+G A-OLC+OLCC+OLJ--Ee---Ev+Eon-uL++uS uH uo w-m! ------END PERL GEEK CODE BLOCK------
select key, sum(val) from table group by key order by sum(val) desc read only the first record