RE: Equivalent query
IDS Version 10.0 will allow you to do the following:
SELECT SKIP 50 FIRST 10 a, b FROM tab1;
________________________________
From: informix-list-bounces@iiug.org
[mailto:informix-list-bounces@iiug.org] On Behalf Of DORN B
Sent: Wednesday, October 04, 2006 8:14 PM
To: luissol
Cc: informix-list@iiug.org
Subject: Re: Equivalent query
TRY: SELECT FIRST <NUMBER OF ROWS> * FROM <TABLE>
On 4 Oct 2006 16:41:32 -0700, luissol <luissol@gmail.com> wrote:
Hello
I have a question is there an equivalent of the "TOP" function of sql
server in informix
I need something like this but in the informix sintax:
DECLARE @var1 integer
SET @var1 = (select count(*) from table)
DECLARE @var2 integer
SET @var2 = 200
select top (@var1 - @var2) * from table
I'm using C# to develop my application that has access to informix but
_______________________________________________
Informix-list mailing list
Informix-list@iiug.org
http://www.iiug.org/mailman/listinfo/informix-list