Computer Science
The HAVING clause acts like a WHERE clause, but it identifies groups that meet a criterion, rather than rows.
Answer
True
Reason — The HAVING clause in SQL is used to filter groups based on specified conditions, while the WHERE clause filters individual rows. This means that the HAVING clause works with grouped data, applying conditions to groups that meet certain criteria, whereas the WHERE clause applies conditions to individual rows before any grouping occurs.
Related Questions
Fill in the blanks:
To get data from two or more tables having some common fields, _________ query is created.
Fill in the blanks:
In equi-join, the join condition joins the two table using _________ operator.
Data manipulation language (DML) commands are used to define a database, including creating, altering, and dropping tables and establishing constraints.
The SQL keyword GROUP BY instructs the DBMS to group together those rows that have the same value in a column.