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

0 vote145 views3 answers
Constraint sql
SQL
20 votes136 views6 answers
Mysql reset auto increment
SQL
0 vote118 views2 answers
Nosqlbooster query other collection
SQL
3 votes124 views2 answers
Tsql join multiple record in one string
SQL
10 votes122 views4 answers
Drop primary key
SQL
8 votes141 views1 answer
Oracle search stored procedures for text
SQL
0 vote132 views1 answer
Mysql update from select on same table
SQL
0 vote130 views1 answer
Mysql docker image arjun
SQL
1 vote120 views1 answer
How to open closed port mysql in ubuntu
SQL
2 votes123 views1 answer
Oracle find unusable indexes
SQL