mySQL - Obtain only users from a table with max points

I need to obtain n users from a table with the max points.

Table

id   name   points
1     pep     4
2     roky    5
3     jhon    2
4     sant    5

The query result will be 'roky' and 'sant开发者_运维知识库'.

I have used a subquery like this

SELECT name FROM table
WHERE points = (SELECT MAX(points) FROM table)

Is it possible to do with only one query (no sub-queries and no joins)?

You're pretty much on the right track. It needs a subquery of some sort.

See here to see how the MySQL manual does it.

I'm really not sure if this could work. Select the max points from the table, then join itself using the points number. It could potentially display the needed names without a subquery. But of course, the subquery is the better (and faster) answer.

SELECT max(t1.points) as maxpoints, t2.name FROM table t1
INNER JOIN table t2 on t2.points = maxpoints

Edit: Wait, what? No joins? Since when was this part of the task? Okay, my solution was outdated while writing it. Oh well.

Sort the result by row and get the first one.

SELEC name FROM table
ORDER BY points DESC
LIMIT 1