Re: Select count(*) problem

From: Carlos Benjamin <benj@linuxstart.com> > >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? He must be. I just hope his wife doesn't catch him at it! ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com