Question

Which ORDER BY clause causes 10 rows to be retrieved from the result set, starting with the 20th row?

Answer 1

Limiting the number of results to 10 is typically not achieved in the ORDER BY clause. You would do it with the TOP or LIMIT or ROWNUM keyword, depending on your database technology.