You have to use the following:
SELECT name FROM mydb ORDER BY score DESC LIMIT 10,10;
Check this out!
The two arguments 10,10 are (Offset, Limit). Hence, the above is going to retrieve rows 11-20.
9,11 Would be needed to take the 10th - 20th rank.
Want to learn more concepts related to SQL? Join SQL Certification course fast!