Home » MCQs » MySQL MCQs

Suppose you have 1000 records and you only want 100 records which of the following clause you will use?

28. Suppose you have 1000 records and you only want 100 records which of the following clause you will use?

1. SET LIMIT
2. LIMIT
3. HAVING
4. GROUP BY

Answer: B) limit clause

Explanation:

The LIMIT clause helps us to set a limit to records we want in return as a result.