Which of the
following statement(s) is/are true about “HAVING” and “WHERE” clause in SQL?

Question

Answer

"WHERE” is always used after “GROUP BY” and “HAVING”
before “GROUP BY”

Answer

"WHERE” is always used before “GROUP BY” and HAVING
after “GROUP BY”

Answer

“WHERE” is used to filter groups but “HAVING” is used
to filter rows

Answer

“WHERE” is used to filter rows but “HAVING” is used to
filter groups

Crowdly