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

13 votes259 views4 answers
What is sql
SQL
32 votes272 views6 answers
Rename column mysql
SQL
1 vote249 views1 answer
Sql order by where condition
SQL
2 votes236 views2 answers
Sql strip non alphanumeric characters
SQL
5 votes256 views3 answers
DBMS_OUTPUT.PUT_LINE
SQL
3 votes250 views2 answers
Find string in stored procedure sql server
SQL
0 vote225 views1 answer
AddEntityFrameworkSqlite
SQL
5 votes252 views1 answer
Sql add column after another
SQL
5 votes223 views1 answer
Mysql get last day of month
SQL
8 votes236 views1 answer
Database backup in mysql server recovery
SQL