Re: Select count(*) problem

Carlos Benjamin wrote: > > Mark D. Stock <mdstock@mydas.freeserve.co.uk> wrote: > > >"COOPER, Joseph" wrote: > >> > >> > I use informix online on HP-UX and am having problems with a select. > >> > The following query: > >> > select count(*)> >> > >> SELECT count(*) , DBINFO('sqlca.sqlerrd2')> >> > >> > from table_x > >> > where > >> > column_a=12345 > >> > group by column_b > >> > >> HAVING count(*) > 200 > > > >That's the coolest answer I've seen on this thread so far. :-) > > > >Cheers, > >-- > >Mark. > > Meanwhile, back at the ranch..... > > >That's NOT the coolest answer on this thread so far. :-( > > > >Selecting the number of rows processed for the first record only must > >surely return 1. > > > >Cheers, > >-- > >Mark. > > Feeling a little schizophrenic today? Feeling a little dyslexic today? I see you conveniently chopped Joseph's SECOND post. The NOT so cool one? RTFA! :-) Cheers, -- Mark. +----------------------------------------------------------+-----------+ | Mark D. Stock mailto:mdstock@mydas.freeserve.co.uk |//////// /| | http://www.informix.com http://www.informixhandbook.com |///// / //| | http://www.iiug.org +-----------------------------------+//// / ///| | |This email will self-destruct in |/// / ////| | |10 sec. If you received this email |// / /////| | |in error, sorry about the mess. |/ ////////| +----------------------+-----------------------------------+-----------+