0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for administrators and users of the CiviCRM Constituent Relationship Management software

select 
  Reputation, 
  DisplayName, 
  ROW_NUMBER() over ( order by Reputation desc)  
    
FROM
    Users
    Where LOWER(Location) IN ('hong kong') and Reputation > 1000
order by Reputation desc

fork query

edited nov 13

created nov 13 MasterWil