If sal is null then replace it with min(sal). Can any one write a query for th

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

Advance Thanks

Question Posted / cmanojkumar

Answers were Sorted based on User's Feedback

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

Answer / madhu

here is the query
update emp set sal =(select min(sal) from emp) where sal is null

Is This Answer Correct ?

9 Yes

0 No

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

Answer / 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

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

Answer / abc

update emp_test set comm=(select min(sal) from emp_test)
where comm is null;

Is This Answer Correct ?

1 Yes

0 No

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

Answer / amol m

SELECT DECODE(w.salary,NULL,(SELECT MIN(e.salary) FROM
employees e),w.salary) FROM employees w

Is This Answer Correct ?

1 Yes

0 No

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

Answer / priyank

select (case when sal is null then (select min(sal) from
emp) end) from emp

Is This Answer Correct ?

1 Yes

0 No

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

Answer / eval

update emp_test set comm=(select min(sal) from emp_test)
where comm is null;

Is This Answer Correct ?

0 Yes

0 No

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

Answer / basavan

select nvl(sal,min(sal) from <table name>

Is This Answer Correct ?

1 Yes

8 No