1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

-- Top users from Münster, Germany


SELECT
    ROW_NUMBER() OVER(ORDER BY Reputation DESC) AS [#], 
    Id AS [User Link], 
    Reputation
FROM
    Users
WHERE
    Reputation >= 1000 AND (
    LOWER(Location) LIKE '%münster%'
    OR UPPER(Location) LIKE '%MÜNSTER%'
    or Location like '%Münster%'
    or LOWER(Location) LIKE '%muenster%'
    OR UPPER(Location) LIKE '%MUENSTER%'
    or Location like '%Muenster%'
    )
ORDER BY
    Reputation DESC;

fork query

edited feb 16

created feb 16 Luca.Kiebel