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

1 vote258 views1 answer
Metada in sql
SQL
3 votes320 views1 answer
Laravel paginate raw sql
SQL
1 vote291 views1 answer
Mysql change root mysql_native_password
SQL
0 vote266 views2 answers
Avg() sql
SQL
0 vote308 views3 answers
Classement rang mysql 7
SQL
0 vote299 views1 answer
Order by in codeigniter query builder
SQL
0 vote310 views1 answer
Print boolean in plsql
SQL
0 vote270 views1 answer
Sql min
SQL
2 votes273 views2 answers
Function in sql
SQL
1 vote307 views1 answer
Pgsql sum switch case
SQL