Re: Select-Statement (TOP)

Posted in 1998

Scott Kolaya — Tue, 15 Sep 1998 00:24:56 -0400 — source: Informix-list mailing list archive (1991-1998)

7.30 has a TOP command. Any older version doesn't. Scott Kolaya Edward Haase wrote in message <6tjknr$rnk$1@news.xmission.com>... > >Hello Yalls, > >which SQL-Command has the same result as > >"SELECT TOP 25 firstname, lastname from students where age > 27 order by >age desc;". > >I'm converting from MS-ACCESS to Informix and didn't find an appropriate >command. > >Thanks, > >Edward > >