Re: R: count(*)

Posted in 1999

Ramdas Gopinath — Thu, 22 Apr 1999 14:17:22 -0400 — source: Informix-list mailing list archive (1991-1998)

Can someone mention which version of SQL allows this sytax ? I do not have ISQL but have DB-ACCESS V 7.23.UC13 on SCO and I too get a Syntax error. Frankly just stick with 'select count(*) from table_name'. Gopi. -----Original Message----- From: Gaetano Mendola <mendola@bigfoot.com> To: informix-list@iiug.org <informix-list@iiug.org> Date: Thursday, April 22, 1999 2:10 PM Subject: R: R: count(*) >Obviously!! > >SELECT COUNT(1) FROM tablename;> >201: A syntax error has occurred.> >Thomas Parsli <thomas.parsli@metamedia.no> wrote in message >90bkn0pz.fsf@metamedia.no... >> "Gaetano Mendola" <mendola@bigfoot.com> writes: >> >> > Is an invalid sintax. >> > Thomas Parsli <thomas.parsli@metamedia.no> wrote in message >> > emlcn215.fsf@metamedia.no... >> > > "Gaetano Mendola" <mendola@bigfoot.com> writes: >> > > >> > > > Hi all, >> > > > >> > > > Is more fast count(*) or count(table.column) ? >> > > > >> > > > I have Informix SE-ONLINE 7.23. >> > > > thanks in advance. >> > > >> > > Probably "COUNT (1) FROM tablename" >> >> Just add water/SELECT: >> "SELECT COUNT(1) FROM tablename" >> >> Thomas > >