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 about the site for administrators, end users, developers and designers for Craft CMS

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

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

fork query

edited aug 12 bravemaster

created apr 2 11 Sandy