RE: Select first with rownumber ?
-----Original Message-----
From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org]
On Behalf Of ptitchuisse
Sent: 15 September 2005 10:01 AM
To: informix-list@iiug.org
Subject: Re: Select first with rownumber ?
>Hi Hendrik,
>Because you rownumber is include in the *, you don't have to add it in
the
>select and do it as follow:
>
>select first 10 * from table order by rownumber;
I don't think this is correct. The * will give you everything except
for the rowid. To get the rowid you specifically have to specify it.
Rowid,* ......
sending to informix-list