-
decode in order by
Hi,
I want to use decode in order by in following way -
select * from dept
order by decode(.......)
if deptno=1 then order by deptname desc, deptcity asc
if deptno=2 then order by deptno desc, deptname asc, deptcity desc
else
order by deptno desc, deptcity asc.
Can anyone please help me?
Thank you in advance.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|