If some one tell me where exactly I use 'having' and 'where' ...

3rd Jul 2016, 3:43 PM
Umar Mir
Umar Mir - avatar
2 Answers
having is used to select group and used in groupby clause
5th Jul 2016, 3:38 AM
shubham kumar
shubham kumar - avatar
where eg: select name from emp(table name) where id in(1,3,6) having is same as where but used after group by clause eg: select * from emp(table name)select sum(salary),deptno from emp group by deptno having sum(salary)>5000
8th Jul 2016, 8:15 AM