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?
- SET LIMIT
- LIMIT
- HAVING
- 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.