Oninit cdi / Archive
Talk to an expert →

Equivalent query

Posted in 2006

Topics: General Discussion

luissol — — source: Usenet: comp.databases.informix

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

↪ replying to luissol
DORN B — — source: Usenet: comp.databases.informix

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 >

Related threads