Re: row multilication

"Norazman" <norazman_at_ti.com> wrote in message news:<9ehvt4$o84
> Anybody know how to get a multiply of return row from a query.
> Example:
> Age:
> ----
> 1
> 2
> 3
> 4
> ----
> 24 - result of multilying 1x2x3x4
>
> Thanks

I'm sure it's not the most efficient way, but you could do a:

select avg(age)*count(rowid) Product from user;

Whatever, eh?

Paul Received on Thu May 24 2001 - 19:17:11 CDT