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

Report message to a moderator

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

Report message to a moderator

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.

Report message to a moderator

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

Report message to a moderator

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 ,

Report message to a moderator

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: 913
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.

Report message to a moderator

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

Report message to a moderator

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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Nov 30 00:00:34 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.