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 ) FROM Users Where LOWER(Location) IN ('hong kong') order by Reputation desc offset 1 row