Try like this If you are using Sql Server 2008 R2 , It'll work,
And i am considering table name as Table1 and sample column name as Name,Column2,Column3.
with cte as (select a.Name,a.Column2,a.Column3,MAX(a.Salary) as Max_Salary,ROW_NUMBER() over(order by a.Name) as Rn from Table as a group by a.Name,a.Column2,a.Column3 ) select * from cte where Rn in (1,3,5)
Checked and it works,
Hope it will be helpful to you.