1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for scholars and enthusiasts of literature

SELECT
    Top ##num?500##
    ROW_NUMBER() OVER(ORDER BY Reputation DESC) AS [#], 
    Id AS [User Link], 
    Reputation,
    Location,
    --CreationDate,
    LastAccessDate,
    UpVotes,
    DownVotes
    
FROM
    Users
WHERE
  (Location LIKE '%##city?slovenska##%' COLLATE Latin1_General_CI_AI)
  and LEN(Location) > 1
 
 ORDER BY Reputation DESC

fork query

created jun 13 20 Martin20528