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
- 2 Answers
- 5069 Views
- i2, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / pranab
having cluase can only be used with group by clause.
if there are 500 records i will give rownumber<250 then it
fetch 249 records.
NVL2( string1, value_if_NOT_null, value_if_null )
if string1 is not null then it returns 'value_if_NOT_null'
and if string1 is null then it returns 'value_if_null'.
if there are four tables without using cartesian we have n-
1 join where n is number of tables. i.e 4-1=3 join required
four tables without using cartesian.
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / 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 |
what is thae main difference between foreingkey and primarykey
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
in fun why return single value?
I have table that has student names in it.If I query on the names my result set should return as 'VALUE NOT ENTERED' for null entries.
REGULAR CLASSES for Informatica 8.6 is starting from Monday, 07th Nov, 8:00 AM IST .
what is difference between sap and oracle applications and which is now market leader?
11 Answers Amity, Infosys, Rysigo, Unilogic Software, Wipro,
i want to know rdbms certification details and syallabus and for whom i contact for rdbms certification in bangalore i need answer very urgent please mail to aniltelkar50@gmail.com please as soon as possible
what is difference between sqlserver and oracle?
what is normalization
what are collection attributes
Oracle General 
