Re: Re: Re: Getting the number of rows returned by a select with group by.
?
-----Original Message-----
From: "Obnoxio The Clown" <obnoxio@serendipita.com>
To: "rkusenet" <rkusenet@gmail.com>
Date: Thu, 23 Sep 2004 21:40:50 +0100 (BST)
Subject: Re: Re: Getting the number of rows returned by a select with group by.
rkusenet said:
> "Jean Sagi" <jeansagi@myrealbox.com> wrote in message
> news:civ3ov$np5$1@news.xmission.com...
>>
>> Hey,
>>
>> This works on 9.3, !! Really cool!
>>
>> Usually I insert the result into a temporary table and then count it or
>> If using 4gl I access
> sqlca or if using dbaccess i unload to a temporary file and look for the
> number of unloaded rows...
>>
>> Sorry it doesn't work on 7.31...
>
> works in 9.21 too.
>
> Wow !!! this is COOOOOOOL.
>
> I never thought I could clone DERIVED tables (as it is called in SQL
> Server)
> using TABLE (MULTISET).
<sigh>
Maybe now all that OR malarkey will catch on as well!
--
Bye now,
Obnoxio
"C'est pas parce qu'on n'a rien ' dire qu'il faut fermer sa gueule"
- Coluche
"I'm trying to see things your way, but I can't get my head up my ass"
- JCH
"Ogni uomo mi guarda come se fossi una testa di cazzo"
- Marco
http://www.catb.org/~esr/faqs/smart-questions.html
sending to informix-list
Jean Sagi
jeansagi@myrealbox.com
jeansagi@yahoo.com
sending to informix-list