select id(identity(int,1,1)),* into #t from 表aselect number,score,rq from #t where id in(select id from #t b where rq=(select max(rq) from #t where number=a.number ) )
select * from tablename A inner join (select number,max(rq) as rq from tablename group by number) B on A.number=B.number and A.rq=B.rq
(select number,max(rq) as rq from tablename group by number) B
on A.number=B.number and A.rq=B.rq