mysql> select name,selecting,rejecting from((select name,selecting,rejecting from ues order by name desc limit 5 )union all(select 'others' as name ,sum(selecting) as selecting ,sum(rejecting) as rejecting from (select selecting,rejecting from ues order by name desc limit 18446744073709551615 offset 5) go)) go; +-------------+--------------+--------------+ | name | selecting | rejecting | +-------------+--------------+--------------+ | normal | 131 | 4 | | spectreRF | 46 | 40 | | vcs | 0 | 0 | | ncsim_short | 0 | 174 | | ncsim_lp | 0 | 3 | | others | 13633 | 659 | +-------------+--------------+--------------+