|
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
|