SQL ORDER BY
 

HI

I use this question and it works fine but I want to sort it in the same
order as the "IN list"

SELECT ID, firstname, lastname FRON person WHERE ID IN (6,2,8)

Now I want it to be sorted in the same order as "IN (6,2,8)" I mhave
tried ORDER BY FIELD(ID, 6,2,8) but then I get an error

IS thier someone who knows somthing about this?

Thanks in advance


*** Sent via Developersdex http://www.developersdex.com ***

SQL ORDER BY
 

You'll have to use something like decode() to do this.

.... order by decode(ID,6,1,2,2,8,3)

or whatever is the equivalent in your particular database.

Tim

"Kalle" wrote in message
...

HI

I use this question and it works fine but I want to sort it in the same
order as the "IN list"

SELECT ID, firstname, lastname FRON person WHERE ID IN (6,2,8)

Now I want it to be sorted in the same order as "IN (6,2,8)" I mhave
tried ORDER BY FIELD(ID, 6,2,8) but then I get an error

IS thier someone who knows somthing about this?

Thanks in advance


*** Sent via Developersdex http://www.developersdex.com ***

SQL ORDER BY
 

Hi


Thanks for your answer but it does't work.

I use an excel worksheet as datebase. Maybe it does't support decode?

Kalle

*** Sent via Developersdex http://www.developersdex.com ***

SQL ORDER BY
 

sSQL = " select col1, col2 from src_rng_name " & _
" order by switch(col1=6, 1, col1=6, 2, col1=6, 3) "

Tim

"Kalle" wrote in message
...


Hi


Thanks for your answer but it does't work.

I use an excel worksheet as datebase. Maybe it does't support decode?

Kalle

*** Sent via Developersdex http://www.developersdex.com ***