Re[2]: SET ROWCOUNT

Sujit is correct. SET ROWCOUNT is a Sybase statement. Scott Patterson Sr. DBA/DA pattersons@norand.com Norand Corp. ______________________________ Reply Separator _________________________________ Subject: Re: SET ROWCOUNT Author: Roger Tomas <tomasr@agcs.com> at smtpgate Date: 7/9/97 5:50 PM Sujit Pal wrote: > > Lately there has been some postings advising to SET ROWCOUNT n to get = > the first n rows of a query, for example: > > SET ROWCOUNT 3; > SELECT * FROM employee ORDER BY salary DESC;> > will return the top 3 earners in the database. > > I have been trying it on my databases here but it bombs out at ROWCOUNT = > with a 201: Syntax Error has occured. I have 7.14.UD1 and 7.20.UC2 here = > and they are both giving me errors. What version of dbaccess / isql is = > this supported? I believe the original post was cross-posted to both the Informix and Sybase newsgroups. Perhaps the SET ROWCOUNT statement belongs to Sybase? ----------- Roger Tomas AG Communication Systems