Re: Select count(*) problem

Carlos Benjamin wrote: > > Mark D. Stock <mdstock@mydas.freeserve.co.uk> wrote: > > >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. > > Someone(?) said that might get you stirred up! > > I was skimming through pretty fast when I saw what I thought was someone contradicting your earlier post. Then I saw it was you! Heck, even if I saw the difference I still woulda thought it was funny. Well we all make mistakes. > But since you thought I 'conveniently' chopped the second post, I probably should've asked if you were feeling paranoid instead. No, it looked like you thought it was the same post. It's YOU we are worried about. Maybe you should cut down on the caffeine. ;-) 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. |/ ////////| +----------------------+-----------------------------------+-----------+