What is the difference between a HAVING CLAUSE and a WHERE CLAUSE?
Bhasker Das
Select an image from your device to upload
when we are using group by clause to apply condition on group of rows Having clause will be used.having clause follows Group by clause.
where clause will be used for condition on single row.
where clause comes before group by clause
select empname,salary from employee where empname like '%raj%' group by salary having salary>30000