NVL2 function, need to display empid Options

[thiyagusham]

SQL> select * from samp;


NAME DOJ QUAL EMPID
---------- --------------- ---------- -----
sam 21-mar-2012 mca
sony 03-jan-2000 mba 10610
maya 21-mar-2012 m.arch
sonna 18-mar-2012 mis

SQL> select name,doj,qual,empid,
2 nvl2('',doj,'new joinee')"RESULT" from samp;

NAME DOJ QUAL EMPID RESULT
---------- --------------- ---------- ----- - -------------
sam 21-mar-2012 mca new joinee
sony 03-jan- 2000 mba 10610 new joinee
maya 21-mar-2012 m.arch new joinee
sonna 18-mar-2012 mis new joinee

i want to display in result column 10610 in second row , because emp sony having id "10610 "
should i use sub-query ? without sub-query how can i display ????
thanks .

[Florin Aparaschi...]

NVL(empid, 'new joinee')