Re: Equivalent query

Posted in 2006

=?iso-8859-1?q?Rich_or_Krist=EDn?= — 5 Oct 2006 02:02:35 -0700 — source: Usenet: comp.databases.informix

luissol wrote: > Hello > > I have a question is there an equivalent of the "TOP" function of sql > server in informix http://publib.boulder.ibm.com/infocenter/idshelp/v10/topic/com.ibm.sqls.doc/sqls653.htm#idx3051 >DECLARE @var1 integer >SET @var1 = (select count(*) from table) >DECLARE @var2 integer >SET @var2 = 200 >select top (@var1 - @var2) * from table You may want to read up on dynamic SQL within Informix too... Rich