select displayname, location, MAX(reputation) from users ...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Islam Meta

Q&A about the site for Muslims, experts in Islam, and those interested in learning more about Islam

select displayname, location, MAX(reputation)
from users
where location = 'South Africa'
group by displayname, location
order by max(reputation) desc

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results