· The IN operator allows you to specify multiple values in a WHERE clause. · The IN operator is a shorthand for multiple OR conditions.
SELECT column_name(s) FROM table_name WHERE column_name IN (value1, value2, …);
SELECT * FROM Employees WHERE Country IN (‘Germany’, ‘France’, ‘UK’);
The SQL HAVING CLAUSE
· The HAVING clause is used instead of WHERE with aggregate functions. · While the GROUP BY Clause groups rows that have the same values into summary rows. · The having clause is used with the where clause in order to find rows with certain conditions. · The having clause is always used after the Group By clause.
SELECT aggregate_function (column_names), column1,column2,…,columnn FROM table_name GROUP BY column_name HAVING aggregate_function(column_name) condition;
Select Sum(Emp_Salary),Emp_City From Employee Group By Emp_City Having Sum(Emp_Salary)>5000;