select min(decode(sal,null,(select min(sal) from emp))) sal from emp grou

If sal is null then replace it with min(sal). Can any one
write a query for this in oracle ?

Advance Thanks

Question Posted / ramesh 9866930212

Answer Posted / ramesh 9866930212

select min(decode(sal,null,(select min(sal) from emp))) sal
from emp group by empno;

Is This Answer Correct ?

4 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What are junk dimensions?

1074

Explain the pipeline partition with real time example?

1144

What are the differences between source qualifier and joiner transformation?

1064

Briefly define a session task?

1138

What are the new features of informatica 9.x developer?

970

What differs when we choose the sorted input for aggregator transformation?

1029

tell me about your project functionality

2347

How can we use batches?

1026

What does update strategy mean, and what are the different option of it?

1094

Explain incremental aggregation in informatica

1134

How to generate sequence numbers without using the sequence generator transformation?

1212

if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.

2201

Describe expression transformation?

1132

i have a data in my source as a flat files what test i have to perform the next step can any body help to me

2125

What is primary and backup node?

1135