create table A ( fd1 int, fd2 int )insert A select 1,2 insert A select 2,1 insert A select 3,1 insert A select 4,3 insert A select 5,4 insert A select 6,4 insert A select 7,2select fd1,fd2, count(*) as num from (select top 1 WiTh Ties * from A order by fd2 DESC) T group by fd1,fd2
(
fd1 int,
fd2 int
)insert A select 1,2
insert A select 2,1
insert A select 3,1
insert A select 4,3
insert A select 5,4
insert A select 6,4
insert A select 7,2select fd1,fd2, count(*) as num from
(select top 1 WiTh Ties * from A order by fd2 DESC) T
group by fd1,fd2