My Rank

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for programmers

SELECT x.position as RANK_IN_INDIA,x.Id as USER_ID,x.Reputation,x.DisplayName FROM 
  (SELECT TOP 150
     ROW_NUMBER() OVER(ORDER BY Reputation DESC) AS position,
     Id,
     DisplayName,
     Reputation
  FROM
     Users
  WHERE
     Location like '%India%'
  ORDER BY
    reputation DESC
   ) x
WHERE x.Id = 3395198

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results