The HAVING clause was added to database because the WHERE ke

The HAVING clause was added to database because the WHERE keyword could not be used with aggregate functions.

Solution

Yes what you said is true.

The syntax of SQL statement with HAVING clause will be like:-

SELECT column_name, aggregate_function(column_name)
FROM table_name
WHERE column_name operator value
GROUP BY column_name
HAVING aggregate_function(column_name) operator value;

The HAVING clause was added to database because the WHERE keyword could not be used with aggregate functions.SolutionYes what you said is true. The syntax of SQ

Get Help Now

Submit a Take Down Notice

Tutor
Tutor: Dr Jack
Most rated tutor on our site