• Hi,

    This query is absolutely woking fine ...but if two employees r aving the same salary then it does not show correct result.. actuly it should show both employees for that rank.

    this can be found using this query...:-->

    select * from @table

    where salary in (select top 1 salary from @table

    where salary in (select top 3 salary from @Table order

    by salary desc

    )

    order by salary

    )

    Looks complicated but not so ...