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 vote256 views1 answer
Mysql change timestamp on update
SQL
2 votes287 views1 answer
How to select from mssql
SQL
0 vote263 views1 answer
Sql get year from datetime field
SQL
0 vote251 views1 answer
Kill thread
SQL
27 votes277 views5 answers
Mysql set password for user
SQL
1 vote259 views1 answer
Increasing font and zooming in mysql workbench
SQL
0 vote264 views1 answer
Update and keep original value sql
SQL
4 votes266 views1 answer
Mysql copy table with new name
SQL
0 vote277 views1 answer
Mysql best varchar length size
SQL
1 vote260 views1 answer
SQLite order random
SQL