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

16 votes132 views6 answers
Mysql find and replace
SQL
8 votes177 views2 answers
Default sql server port
SQL
0 vote126 views1 answer
Like sql for second letter of the family name
SQL
0 vote139 views1 answer
Mysql set boolean default value
SQL
0 vote133 views1 answer
Django mssql backend
SQL
0 vote135 views1 answer
Pl/ sql change currency
SQL
0 vote134 views1 answer
Dump only data
SQL
0 vote144 views1 answer
How to access to mysql without root
SQL
1 vote153 views2 answers
Remove space in mysql
SQL
0 vote125 views1 answer
Restore backup "text" postgresql command line
SQL