Top N selections + rest row

[C.R.Vegelin]

Hi All,

Anybody with smart ideas to get Top-N rows plus the rest row ?
Suppose I have ranked sales values descending for 2005, like:
Select Country, Sum(Sales) AS Sales From myTable
Where Year=2005 Group By Country 
Order By Sales DESC LIMIT 25;

Then I get Top-25 sales rows, but I also want a rest row,
where all 26 rows represent the world total.
I'm using MySQL 5.0.15.

Regards, Cor