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 vote315 views1 answer
Enable full text search mysql
SQL
33 votes324 views6 answers
Change column name in mysql
SQL
0 vote315 views1 answer
Sql server size of every table in a db
SQL
0 vote311 views1 answer
How to drop a column in mysql laravel stackoverflow
SQL
2 votes323 views1 answer
Sql OR
SQL
8 votes322 views1 answer
How to remove tables from postgresql
SQL
3 votes360 views1 answer
Mysql group_concat distinct
SQL
0 vote335 views1 answer
Rename constraint postgresql
SQL
0 vote304 views1 answer
SQL Server modify_timestamp trigger
SQL
0 vote330 views1 answer
Mysql Selected All Duplicate Rows
SQL