What is having clause

HAVING clause in SQL is used to
filter records in combination
with the GROUP BY clause. It is
different from WHERE, since 
WHERE clause cannot filter 
aggregated records. HAVING is a column
operation.

Select department_id, Min (Salary)
From Employees
Group By Department_id
Having MIN (salary) < 3500;

Similar codes

0 vote163 views1 answer
Where case insensitive like mysql
SQL
6 votes280 views3 answers
Psql show columns of table
SQL
3 votes203 views1 answer
Oracle user quota on tablespace
SQL
0 vote278 views3 answers
Get count of null in column sql
SQL
1 vote169 views1 answer
Data type and their numeric form
SQL
2 votes228 views1 answer
Mysql shell insert into
SQL
1 vote183 views1 answer
Mysql last year
SQL
6 votes180 views2 answers
Mysql execute file
SQL
2 votes173 views1 answer
Postgresql update sequence next value
SQL
0 vote222 views1 answer
Sqlalchemy orm duplicate
SQL