0 votes
in DBMS by

HAVING clause: This clause is used in association with the GROUP BY clause. It is applied to each group of results or the entire result as a single group. It is much similar as WHERE clause but the only difference is you cannot use it without GROUP BY clause

Syntax:

SELECT column_name(s)

 FROM table_name

 GROUP BY column_name

 HAVING condition;

Related questions

0 votes
0 votes
asked Sep 9, 2019 in Spark Sql by ivor2019
0 votes
0 votes
asked Jul 13, 2020 in Sql by Robindeniel
...