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

Q&A for researchers, developers, and users of Tor

-- 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

fork query

edited feb 15 24 anonymous

created apr 2 11 Sandy