HAVING:
Thank You. Like Share and Subscribe 👍 Followlect.com
- The HAVING clause used to filter records from of group of data with certain condition
- The HAVING is used along with Aggregate Function.
GROUP BY:
- The GROUP BY is used to group record .
- It can be used along with HAVING clause.
Example.
Employee
id | Emp_name | Age | Salary | Dept_id | Location |
1 | Jebas | 35 | 55000 | 2 | TVL |
2 | Thomas | 30 | 70000 | 1 | TVL |
3 | Mark | 25 | 55000 | 2 | TEN |
4 | Harry | 42 | 55000 | 2 | TUTY |
5 | Willam | 45 | 70000 | 1 | TUTY |
6 | James | 32 | 45000 | 3 | TEN |
7 | Mock | 22 | 45000 | 3 | KOVI |
8 | Sherin | 23 | 12000 | 7 | TUTY |
SELECT location,count(location ) Number_of_Employee
FROM Employee GROUP BY location ;
This statement returns the number of employee come from various location.
Location | Number_of_Employee |
KOVI | 1 |
MDY | 1 |
TEN | 2 |
TUTY | 2 |
TVL | 2 |
SELECT dept_id , SUM(salary) TOTAL_SALARY
FROM Employee GROUP BY dept_id ;
This statement return total salary in each department
Employee
Dept_id | TOTAL_SALARY |
1 | 140000 |
2 | 65000 |
3 | 90000 |
7 | 12000 |
HAVING clause
SELECT dept_id
FROM Employee GROUP BY dept_id HAVING COUNT(dept_id)>2 ;
This statement to find department in which more than two employee work.
Dept_id |
2 |
Thank You. Like Share and Subscribe 👍 Followlect.com
Comments
Post a Comment