Q&A about the site for science fiction and fantasy enthusiasts
-- List of Users in the United Kingdom SELECT Top ##Top## ROW_NUMBER() OVER(ORDER BY Reputation DESC) AS [#], Id AS [User Link], Reputation, Location, --CreationDate, LastAccessDate, UpVotes, DownVotes FROM Users WHERE ( lower(location) like lower('united kingdom') or lower(location) like ('% uk') ) -- exclusions and not ( -- Enter dummy if not required lower(location) LIKE lower('%##Exclusion##%') ) order by location asc -- to pick out incorrect results