TOP 100 users from Singapore

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 are located in Singapore Thanks to http://data.stackexchange.com/stackoverflow/qe/1157/top-100-users-from-greece

Stack Overflow

Q&A for professional and enthusiast programmers

-- TOP 100 users from Singapore
-- Thanks to http://data.stackexchange.com/stackoverflow/qe/1157/top-100-users-from-greece

SELECT TOP 100
   ROW_NUMBER() OVER(ORDER BY Reputation DESC) AS [#],
   Id,
   CreationDate,
   Id AS [User Link],
   Reputation,
   WebsiteUrl,
   Location
FROM
   Users
WHERE
   Location like N'%Singapore%'
ORDER BY
   reputation DESC

Enter Parameters

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