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 vote324 views1 answer
Ignore case in string sql
SQL
2 votes363 views2 answers
Postgresql get table names
SQL
0 vote321 views1 answer
Inner joint
SQL
0 vote322 views1 answer
Sql datediff month
SQL
0 vote380 views1 answer
Postgresql alter table sequence
SQL
0 vote337 views1 answer
Into operator in sql
SQL
2 votes365 views1 answer
Create mysql user on all hosts
SQL
0 vote338 views1 answer
Sql string contains case sensitive
SQL
0 vote337 views1 answer
Not equal to blank in mysql
SQL
36 votes337 views3 answers
Finding duplicate column values in table with sql
SQL