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


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], 

            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

Switch sites:
loading Hold tight while we fetch your results