select row_number() over (order by U.Reputation desc) Sir...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Moderators

Q&A for community managers, administrators, and moderators

select 
  row_number() over (order by U.Reputation desc) Sira
  , U.Reputation - My.Reputation Fark
  , DisplayName
  , Location 
  , WebsiteUrl
  , Age
from Users U
cross apply ( select Reputation from Users where DisplayName= 'nurettin' ) My
where (Location like '%Turkey%' or Location like '%Türk%')
and U.Reputation>= My.Reputation

Enter Parameters

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