Beginner Database Management Systems
Q30 / 100

What is the LIMIT clause in SQL?

Correct! Well done.

Incorrect.

The correct answer is B) Restricting the number of rows returned by a query

B

Correct Answer

Restricting the number of rows returned by a query

Explanation

SELECT * FROM products ORDER BY price DESC LIMIT 10 returns the 10 most expensive products. MySQL/PostgreSQL use LIMIT; SQL Server uses TOP; Oracle uses ROWNUM or FETCH FIRST.

Previous All Questions Next
Progress
30/100
🗄️

Browse All Database Management Systems Questions

100 questions · beginner to advanced