Q&A for scientists using computers to solve scientific problems
declare @numbers table(nums integer); insert into @numbers values (10),(9),(9) ,(8), (2), (10); select top 3 WITH TIES * from @numbers order by nums DESC /* select nums from ( select nums, rank() over (order by nums desc) as rn from @numbers ) t where rn <= 3; */