Home » SQL & PL/SQL » SQL & PL/SQL » interchage sql
interchage sql [message #232846] Mon, 23 April 2007 10:19 Go to next message
pavuluri
Messages: 247
Registered: January 2007
Senior Member
i have table

no
1
2
3
4
5
6
7

i want to output

6
5
4
3
2
1
7


Re: interchage sql [message #232847 is a reply to message #232846] Mon, 23 April 2007 10:30 Go to previous message
Michel Cadot
Messages: 64130
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
select no from tab
order by decode(no,7,0,no) desc;

Regards
Michel
Previous Topic: DBMS_JOB Job not starting.
Next Topic: Trigger problems
Goto Forum:
  


Current Time: Wed Dec 07 10:55:46 CST 2016

Total time taken to generate the page: 0.08298 seconds