SELECT TOP 100 ROW_NUMBER() OVER(ORDER BY Reputation DESC...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Role-playing Games Meta

Q&A about the site for gamemasters and players of tabletop, paper-and-pencil role-playing games

SELECT TOP 100
  ROW_NUMBER() OVER(ORDER BY Reputation DESC) AS [#],
  Id AS [User Link], Reputation,  LastAccessDate, Location
FROM 
  Users 
WHERE 
  LOWER(Location) LIKE '%trinidad and tobago%'
ORDER BY 
  Reputation DESC

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results