TOP 100 users from CHENNAI

0

Please login or register to vote for this query.

(click on this box to dismiss)

Lists the top 100 users (ranked by reputation) that they are located in Chennai,TamilNadu, India according to their profile information.

Science Fiction and Fantasy

Q&A for science fiction and fantasy enthusiasts

-- TOP 100 users from CHENNAI
-- Lists the top 100 users (ranked by reputation) that they are located in Chennai,TamilNadu, India according to their profile information.
-- Created by Mohideen https://stackoverflow.com/users/4453737/mohideen-ibn-mohammed

SELECT TOP 100
   ROW_NUMBER() OVER(ORDER BY Reputation DESC) AS [#],
   Id AS [User Link],
   DisplayName,
   Reputation,
   WebsiteUrl,
   Location
FROM
   Users
WHERE
   Location like N'%Chennai%' and DisplayName like N'o m%'

Enter Parameters

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