in DBMS by
Q:

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 Mar 10, 2021 in PL/SQL by sharadyadav1986
0 votes
0 votes
asked Dec 13, 2020 in Sql by SakshiSharma
0 votes
asked Jul 6, 2020 in Sql by Robindeniel
0 votes
asked Sep 9, 2019 in Spark Sql by ivor2019
...