User List: Top N - Turkey - with false positive exclusion

1

Please login or register to vote for this query.

(click on this box to dismiss)

List of Users in Turkey.

Amateur Radio

Q&A for amateur radio enthusiasts

-- List of Users in a given location
-- This query lists all users in a given location.

SELECT   RankNo, 
         [User Link], 
         Reputation, 
         --DisplayName, 
         Location

FROM
         (
            SELECT Id [User Link], Reputation, Location,
                   DENSE_RANK() OVER (ORDER BY Reputation DESC) RankNo
            FROM   Users

where lower(location) like lower('%##location##%')

    --and not(
    --        lower(Location) LIKE lower('%##exclusion1##%')
    --     OR lower(Location) LIKE lower('%##exclusion2##%')                  
    --        )
    
        ) derivedtable
--order by reputation desc
order by location asc

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results