Home » Developer & Programmer » Reports & Discoverer » order by problem
order by problem [message #90115] Sat, 30 October 2004 03:12 Go to next message
smth
Messages: 2
Registered: October 2004
Junior Member
Hi, i have a table as below

name   -   revenue

ajay    -   332

jonny   -   433

sarra   -   234

yash    -   326

I want to order by name but like this

jonny   -   433

yash    -   326

ajay     -   332

sarra    -   234

Please help me out
Re: order by problem [message #90122 is a reply to message #90115] Mon, 01 November 2004 02:33 Go to previous messageGo to next message
J.S.Rajkumar
Messages: 20
Registered: March 2004
Junior Member
Hi

Your Requirement does not sound good

Please explain what your requirement is (Ex does not look logical)

Thanks
Re: order by problem [message #205370 is a reply to message #90115] Fri, 24 November 2006 06:28 Go to previous messageGo to next message
deni_sa
Messages: 77
Registered: June 2006
Member
In this case u can use
case when name = 'jonny'then 1
when name = 'yash'then 2
when name = 'ajay'then 3
when name = 'sarra'then 4

end


than you can sort the id from 1 to 4 and y'll get the resulr you want for this case

D.
Re: order by problem [message #205376 is a reply to message #205370] Fri, 24 November 2006 06:50 Go to previous messageGo to next message
ab_trivedi
Messages: 460
Registered: August 2006
Location: Pune, India
Senior Member
Hi deni_sa,

Please elaborate the solution ...

Bye
Ashu
Re: order by problem [message #205379 is a reply to message #205376] Fri, 24 November 2006 06:53 Go to previous messageGo to next message
deni_sa
Messages: 77
Registered: June 2006
Member
I don't understand you ,
Re: order by problem [message #205418 is a reply to message #205379] Fri, 24 November 2006 11:09 Go to previous messageGo to next message
skooman
Messages: 912
Registered: March 2005
Location: Netherlands
Senior Member
Can't look inside someone's mind, but what I think: if there is no logic in sorting, then "attach" numbers to values according to the sort you need.
Re: order by problem [message #205445 is a reply to message #205418] Fri, 24 November 2006 21:56 Go to previous messageGo to next message
ab_trivedi
Messages: 460
Registered: August 2006
Location: Pune, India
Senior Member
you are right skooman .

bye
Re: order by problem [message #206034 is a reply to message #90115] Tue, 28 November 2006 06:51 Go to previous message
javed.khan
Messages: 340
Registered: November 2006
Location: Banglore
Senior Member

Need More Explanation...It Seems an Order not on names but on Number in Decendind Order Why dont you try to sort them by this Numbar Feild.

Jak
Previous Topic: get direct print
Next Topic: Detail line is changing my summary results to zero
Goto Forum:
  


Current Time: Sat Dec 10 12:46:07 CST 2016

Total time taken to generate the page: 0.10252 seconds