What is having

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

2 votes408 views2 answers
Create temporary table in mysql
SQL
0 vote377 views1 answer
How to login to mysql in homestead
SQL
1 vote445 views1 answer
Postgresql Insufficient privilege: 7 ERROR: permission denied for table
SQL
5 votes341 views2 answers
Oracle to_timestamp
SQL
1 vote328 views1 answer
Flask-sqlalchemy filter_by contains
SQL
3 votes334 views4 answers
Show sql server database
SQL
3 votes366 views2 answers
Oracle apex charging debug
SQL
16 votes349 views3 answers
Order by sql query
SQL
0 vote344 views1 answer
Mysql Error Code: 1005
SQL
0 vote379 views1 answer
SQL SERVER xquery count child nodes
SQL