0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for serious players and enthusiasts of poker

--SELECT DisplayName FROM USERS
--WHERE LOCATION LIKE '%South Africa' --AND REPUTATION = (SELECT MAX (REPUTATION) FROM USERS) 

SELECT
    DisplayName,
    MAX(REPUTATION)
FROM
    USERS
WHERE LOCATION LIKE '%South Africa'     
GROUP BY DisplayName




--SELECT id,name,class,MAX(mark) as max_mark FROM `student`

--SELECT Id FROM USERS
--WHERE DisplayName = 'Mat Mannion'

--SELECT * FROM PostTypes
--WHERE NAME = 'Question'

--SELECT * FROM POSTS
--WHERE PostTypeId = 1

fork query

edited feb 25 20

created feb 24 20 anonymous