Sorting Problem

Posted in 2006

ggk517@gmail.com — 31 Jul 2006 18:05:53 -0700 — source: Usenet: comp.databases.informix

Hi all, I have a sorting problem. Pls see below sql: SQL: select id from ptable order by id desc Result: id ------ E9333 E9266 E9258 E10691 E10660 Actually, I would like my result to be sorted like that: id ------ E10691 E10660 E9333 E9266 E9258 Which sql query should I use? Thanks for your help.

↪ replying to ggk517@gmail.com

Obnoxio The Clown — Tue, 1 Aug 2006 07:46:34 +0100 (BST) — source: Usenet: comp.databases.informix

ggk517@gmail.com said: > Hi all, > > I have a sorting problem. Pls see below sql: > > SQL: select id from ptable order by id desc > > Result: > > id > ------ > E9333 > E9266 > E9258 > E10691 > E10660 > > Actually, I would like my result to be sorted like that: > > id > ------ > E10691 > E10660 > E9333 > E9266 > E9258 > > Which sql query should I use? > Thanks for your help. Interesting data. If you could lose the char in front, you could say Select id[2, N] + 0 id from table order by 1 desc But if the char in front varies or is important, then it's beyond me at half past seven in the morning. -- Bye now, Obnoxio "... no bill is required as no value was provided." -- Christine Normile

↪ replying to Obnoxio The Clown

bozon — 1 Aug 2006 04:52:42 -0700 — source: Usenet: comp.databases.informix

Select Select id[1,1], id[2, N] + 0 id from table order by 1 desc, 2 desc I would think. Luckily I waited till 7:50 my time to look at it. Obnoxio The Clown wrote: > ggk517@gmail.com said: > > Hi all, > > > > I have a sorting problem. Pls see below sql: > > > > SQL: select id from ptable order by id desc > > > > Result: > > > > id > > ------ > > E9333 > > E9266 > > E9258 > > E10691 > > E10660 > > > > Actually, I would like my result to be sorted like that: > > > > id > > ------ > > E10691 > > E10660 > > E9333 > > E9266 > > E9258 > > > > Which sql query should I use? > > Thanks for your help. > > Interesting data. If you could lose the char in front, you could say > > Select id[2, N] + 0 id from table order by 1 desc > > But if the char in front varies or is important, then it's beyond me at > half past seven in the morning. > > -- > Bye now, > Obnoxio > > "... no bill is required as no value was provided." > -- Christine Normile

↪ replying to ggk517@gmail.com

Art S. Kagel — Tue, 01 Aug 2006 10:51:13 -0400 — source: Usenet: comp.databases.informix

ggk517@gmail.com wrote: > Hi all, > > I have a sorting problem. Pls see below sql: > > SQL: select id from ptable order by id desc > > Result: > > id > ------ > E9333 > E9266 > E9258 > E10691 > E10660 > > Actually, I would like my result to be sorted like that: > > id > ------ > E10691 > E10660 > E9333 > E9266 > E9258 > > Which sql query should I use? > Thanks for your help. Not easy. Try this: select id, id[1,1], (id[2,6] + 0) from ... order by 2, 3; Art S. Kagel