/* MySQL*/
SELECT
   T1.ID,
   sum(T1.CNT)
FROM
   TOV T1
GROUP BY
   T1.ID
ORDER BY sum(T1.CNT) desc
limit  10 ;

/* MS SQL Server/SyBase ASE */
SELECT top  10 
   T1.ID,
   sum(T1.CNT)
FROM
   TOV T1
GROUP BY
   T1.ID
ORDER BY sum(T1.CNT) desc;

select t.id, t.name, sum(t.cnt) as sum_cnt,
       max(v1.max_sum_cnt)
  from t
  cross join 
        (
          select max(sum_cnt) as max_sum_cnt
            from (
                   select sum(cnt) as sum_cnt
                     from t
                    group by id
                 ) v0
        ) v1
 group by t.id, t.name
having max(v1.max_sum_cnt) = sum(t.cnt)
 order by t.id

select t1.id, t1.name, t1.cnt
  from tov t1
  join tov t2
    on t1.cnt <= t2.cnt
   and t1.id != t2.id 
 group by t1.id, t1.name, t1.cnt
having count(distinct t2.id) <= :N
 order by count(distinct t2.id), id

select t1.id, t1.name, t1.cnt
  from tov t1
  join tov t2
    on t1.cnt <= t2.cnt
 group by t1.id, t1.name, t1.cnt
having count(distinct t2.cnt) <= :N
order by count(distinct t2.id), id

create table TOV
(
    ID int not null,
    CNT int
)

insert into TOV (ID, CNT) values ( 1 ,  10 )
insert into TOV (ID, CNT) values ( 2 ,  200 )
insert into TOV (ID, CNT) values ( 3 ,  3000 )
insert into TOV (ID, CNT) values ( 1 ,  20 )
insert into TOV (ID, CNT) values ( 2 ,  400 )
insert into TOV (ID, CNT) values ( 3 ,  6000 )
insert into TOV (ID, CNT) values ( 4 ,  5000 )
insert into TOV (ID, CNT) values ( 5 ,  110 )
insert into TOV (ID, CNT) values ( 2 ,  4400 )

select  t1.id, t1.cnt
    from  (select id, sum(cnt) as cnt from tov group by id) t1
    join  (select id, sum(cnt) as cnt from tov group by id) t2
      on  t1.cnt<= t2.cnt
   group  by  t1.id, t1.cnt
having  count(distinct  t2.cnt)<= :N
order  by  count(distinct  t2.id), id