can we use a having cluase in groupby clause.
if there are 500 records i will give rownumber<250 then how
many records does it retrieve.
wt is the result of nvl2(null,notnull,null)
if there are four tables without using cartesian how many
joins can be there.
in the sql subqueries wt is the parent ans1)select
2)update,3) delete 4)2&3
Answer Posted / chiranjeevi
Normal Group By Query
-------------
select deptno,count(*) from emp
group by deptno
-----------------
Deptno Count(*)
------ --------
30 4
20 7
10 3
Why not,you just fallow the bellow Query...
----
Group By With Having Clasue
---
select deptno,count(*) from emp
group by deptno
having count(*)>3
----
Deptno Count(*)
------ --------
30 4
20 7
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers