Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 *** |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 *** |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 *** |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 *** |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to change series plotting order without changing legend order? | Charts and Charting in Excel | |||
For chart syles, why doesn't color order match series order? | Charts and Charting in Excel | |||
How stop Excel file UK date order changing to US order in m.merge | Excel Discussion (Misc queries) | |||
Daily Macro to Download Data, Order and paste in order | Excel Worksheet Functions | |||
Daily Macro to Download Data, Order and paste in order | Excel Programming |