Complicating a little too much...
I hope this will solve your problem.
SELECT
DECODE(acno,'555555666666666',1,'333333333333333',2,3) sort_order, acno
FROM rcb_acct
WHERE lgon_pref = 'MYN'
ORDER BY sort_order, acno
Cheers,
Nanda
|
Results 1 to 9 of 9
Thread: SQL QuestionThreaded View
|
Click Here to Expand Forum to Full Width |