SQL Server 2008: TOP 10 and distinct together March 27, 2023 by Tarik Try SELECT TOP 10 distinct MyId FROM sometable;