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

2 votes468 views5 answers
Unique in sql server
SQL
0 vote293 views1 answer
Get current date data in mysql
SQL
0 vote288 views1 answer
Sql get number of days between two dates
SQL
0 vote305 views1 answer
Firebase sql
SQL
2 votes297 views2 answers
Mysql search for column name in all tables
SQL
0 vote315 views1 answer
Use of undefined constant mysql_assoc - assumed
SQL
7 votes268 views1 answer
Sql management studio display line numbers
SQL
0 vote292 views1 answer
View to table sql
SQL
0 vote257 views1 answer
Oracle index hint multiple tables example
SQL
1 vote280 views1 answer
Mysql view current queries
SQL