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

2 votes114 views2 answers
How to add not null constraint in sql
SQL
2 votes128 views1 answer
Grant revoke privileges to mysql username
SQL
0 vote116 views1 answer
Grant privileges mysql to database 1064
SQL
0 vote109 views1 answer
Get enginge db mysql
SQL
28 votes118 views6 answers
Foreign key
SQL
8 votes108 views1 answer
Oracle search source code
SQL
9 votes105 views1 answer
Mysql check date range
SQL
1 vote127 views1 answer
Mysql select for update ejemplo
SQL
5 votes129 views1 answer
Oracle asynchronous query
SQL
0 vote110 views1 answer
Oracle synonym procedure
SQL