RE: FW: Query

Posted in 2005

shahid.mehmood — Mon, 12 Sep 2005 09:34:57 +0500 — source: Usenet: comp.databases.informix

Sending again ... I didn't get the reply ... IF you have already done so ... Sorry about that ... But ... I am novice to this ... Can you send me the SQL for limited number of columns, say 5? Thanks Sm/.. -----Original Message----- From: Jean Sagi [mailto:jeansagi@myrealbox.com] Sent: Friday, September 09, 2005 10:55 AM To: shahid.mehmood Cc: informix-list@iiug.org Subject: Re: FW: Query It could be done, but you must know the exact number of columns, if so then You can use decode to achieve what you want. If the number of columns is not know then I don't know, althoug in this case I think that could not be done using normal SQL. J. shahid.mehmood escribis: > I want the return rows into columns, like > > > > The return rows in a select > > 1 > > 2 > > 3 > > 4 > > 5 > > > > Appear as > > 1 2 3 4 5 > > > > Is it possible? > > > > Thanx, > > S m > sending to informix-list sending to informix-list