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

0 vote312 views1 answer
Oracle insert single quote in string
SQL
0 vote287 views1 answer
What is the difference between the LIKE and REGEXP operators in mysql?
SQL
0 vote301 views1 answer
Get clob size oracle
SQL
-1 vote296 views1 answer
Default username and password for oracle 11g
SQL
1 vote272 views1 answer
Lpad function in sql oracle
SQL
0 vote296 views3 answers
How to run sql query
SQL
0 vote299 views1 answer
Mysql uuid
SQL
0 vote271 views1 answer
Sql server select top 2 of each group
SQL
4 votes290 views1 answer
Oracle error line
SQL
1 vote260 views1 answer
Select not matching data from two tables
SQL