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.

Keep practicing — related questions