I think paul last Query and my Query both are same.

Select U.* from dbo.Users U with (Nolock)

Join (Select username, MAX(GWP) MGWP from dbo.Users with (Nolock)

Group by username) as A

on A.UserName=u.UserName and A.MGWP=U.GWP

suggestions are welcome.