0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for music historians, critics, and fans

-- top users: Hyderabad, India
-- List of Hyderabad based users by reputation score. 

select * from (
SELECT
    ROW_NUMBER() OVER(ORDER BY Reputation DESC) AS [#], 
    Id AS [User Link], 
    Reputation
FROM
    Users
WHERE
     LOWER(Location) LIKE '%hyd%'
-- ORDER BY Reputation DESC
) rows
where [User Link]='767881'

fork query

edited apr 22 14

created apr 22 14 anonymous