In SQL, what is the purpose of the WHERE clause in a SELECT statement?
- Groups the rows
- Limits the rows returned
- Orders the result set
- Specifies the columns
The WHERE clause filters rows in a SELECT statement based on a specified condition. It is used to extract only the rows that fulfill a specified condition or criteria from a table.
Loading...
Related Quiz
- Historical performance data in DB2 is valuable for ________.
- What actions can the Health Monitor take in response to identified issues?
- What information does the Runstats utility collect in DB2?
- Scenario: A software development team is experiencing slow query performance in their DB2 database. How can they leverage normalization and denormalization techniques to optimize database performance?
- What does the version number of DB2 signify?