Which SQL clause limits a SELECT query to return at most 10 rows in standard SQL?

Advanced SQL Developer Easy

Advanced SQL Developer — Easy

Which SQL clause limits a SELECT query to return at most 10 rows in standard SQL?

Key points

  • LIMIT 10 / FETCH FIRST 10 ROWS ONLY is the standard SQL syntax for limiting the number of rows.
  • ROWCOUNT 10, SELECT TOP 10, and ROWS = 10 are not valid SQL clauses for limiting rows.
  • Understanding the correct syntax for limiting rows is essential for controlling query results.

Ready to go further?

Start full exam Practice more questions

Related questions