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 vote139 views1 answer
SQLite3::SQLException: table "categories" already exists: CREATE TABLE "categories" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL
SQL
6 votes152 views1 answer
Identify primary key in oracle table
SQL
0 vote154 views2 answers
Dumping sql table
SQL
0 vote143 views1 answer
SAP Return
SQL
2 votes187 views1 answer
Show max_allowed_packet mysql
SQL
0 vote147 views1 answer
Oracle list datafiles
SQL
0 vote161 views1 answer
Simple plsql program run in oracle sql developer but got the error
SQL
1 vote150 views1 answer
Postgresql how to show table names
SQL
2 votes155 views2 answers
Sql lag
SQL
0 vote138 views1 answer
Mysql grant all on all databases
SQL