Q&A about the site for engineers, producers, editors, and enthusiasts spanning the fields of video, and media creation
declare @numbers table(nums integer); insert into @numbers values (10), (9), (8), (8), (2), (10); select nums from ( select nums, rank() over (order by nums desc) as rn from @numbers ) t where rn <= 3;