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 vote349 views1 answer
Oracle get current schema
SQL
0 vote335 views1 answer
Creation d'un trigger sql
SQL
1 vote339 views1 answer
Oracle sequence last_number
SQL
0 vote317 views1 answer
Get record which is available in one table but not in another mysql
SQL
1 vote541 views3 answers
Sql subquery
SQL
0 vote330 views1 answer
Create relationship with betwen two tables in postgersql
SQL
27 votes347 views3 answers
Mysql show tables in database
SQL
2 votes347 views1 answer
Get the mysql table columns data type mysql
SQL
4 votes333 views1 answer
Group by mysql and concatenate string
SQL
0 vote320 views1 answer
Restore backupfile discourse
SQL