Multiple choice technology databases

What will be the output of the query SELECT column FROM table ORDER BY column DESC LIMIT 7,10;

  1. Would skip the first 7, and then get you the next ten highest.

  2. not a valid mysql query

  3. Would skip the first 10, and then get you the next 7 highest.

  4. None of the above
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

The LIMIT clause with two parameters (LIMIT 7,10) means skip the first 7 rows (offset) and return the next 10 rows. Combined with ORDER BY column DESC, this skips the 7 highest values and returns the next 10 highest values.

AI explanation

MySQL's LIMIT offset, count syntax treats the first number as how many rows to skip and the second as how many rows to return afterward, so LIMIT 7,10 skips the first 7 rows of the (descending) result and returns the next 10. It's valid MySQL syntax, so 'not a valid query' doesn't apply, and the offset/count roles aren't reversed as the third option claims.

Keep practicing — related questions