Select a column that is not in the order-clause ?

Posted in 1998

Bernhard Derix — 4 May 98 16:05:20 GMT — source: Informix-list mailing list archive (1991-1998)

Is this possible ? I'd like to sth. like this: select columnY from (select * from tableXY order by columnX); But this syntax isn't possible. I know it's possible through a view, but I don't want to use this. -- Bernhard Derix email: derix@forwiss.uni-passau.de Homepage: http://www.forwiss.uni-passau.de/~derix/ Universitaet Passau, FORWISS, Zi. FMI 034, Innstr. 33, 94032 Passau Tel.: 0851/509-3144