SELECT name FROM mydb ORDER BY score DESC LIMIT 10;
The query above will return the first 10 ranks.
How to modify the LIMIT, or maybe is there another syntax to query the 10th rank through the 20th rank?
LIMIT