Re: Select count(*) problem
"COOPER, Joseph" wrote:
>
> > I use informix online on HP-UX and am having problems with a select.
> > The following query:
> > select count(*)>
> Or if using 7.3+ try
>
> SELECT FIRST 1 DBINFO('sqlca.sqlerrd2')>
> > from table_x
> > where
> > column_a=12345
> > group by column_b
>
> HAVING count(*) > 200
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.
+----------------------------------------------------------+-----------+
| 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. |/ ////////|
+----------------------+-----------------------------------+-----------+