Hi,
Please correct me if I am wrong
select * from emp
where deptno = &dpt
order by decode(&dpt,10,ename,
20,hiredate||','||job||','||sal,
30,deptno||','||ename,'')
Thanks
|
Results 1 to 3 of 3
Thread: Order By Decode - QuestionThreaded View
|
Click Here to Expand Forum to Full Width |