Thread: SQL specified sort

SQL specified sort

From
"jeffrey morrison"
Date:
I was wondering if you could help me out with a problem I'm having. Say for 
example I have data coming out like:
H29
214
200
099

How would I use a sort to be able to make the output look like

214
H29
200
099

I don't believe their is a way to do an ORDER BY in a specific order. Any 
help you could give me this problem would be very much appreciated.

Jeff Morrison
_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.



Re: SQL specified sort

From
"tjk@tksoft.com"
Date:
Jeff,

If you want to receive your data in an order which 
you specify manually, the easiest way to accomplish this
is to add a separate field which contains an int4 value
used by you to specify the order.

E.g. 

myval   |   sortint
_____________________H29    |   2214    |   1200    |   3099    |   4


SELECT myval FROM mytable ORDER BY sortint;



Troy



> 
> I was wondering if you could help me out with a problem I'm having. Say for 
> example I have data coming out like:
> H29
> 214
> 200
> 099
> 
> How would I use a sort to be able to make the output look like
> 
> 214
> H29
> 200
> 099
> 
> I don't believe their is a way to do an ORDER BY in a specific order. Any 
> help you could give me this problem would be very much appreciated.
> 
> Jeff Morrison
> _________________________________________________________________________
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>