Re: Select count(*) problem

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. But since you thought I 'conveniently' chopped the second post, I probably should've asked if you were feeling paranoid instead. carlos Currently on hiatus from unemployment. ---------------------- Do you do Linux? :) Get your FREE @linuxstart.com email address at: http://www.linuxstart.com