Which SQL clause is used to filter records in a SELECT statement?
- FILTER
- GROUP BY
- HAVING
- WHERE
The SQL clause used to filter records in a SELECT statement is the WHERE clause. It allows you to specify conditions that the rows must meet to be included in the result set. This is essential for retrieving specific data based on criteria such as values in certain columns or combinations of conditions.
Loading...
Related Quiz
- The "A" in ACID properties guarantees that database transactions are ___________.
- Which operation in queues removes an element from the front?
- In Angular, what is the purpose of NgModule?
- In a distributed system, you need to efficiently search for a particular value across multiple sorted arrays. How would you approach this problem?
- What is the role of page replacement algorithms in memory management, and give examples of such algorithms.