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
- 5094 Views
- i2, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
