List:General Discussion« Previous MessageNext Message »
From:Martin Ramsch Date:September 17 1999 12:15am
Subject:Re: acumulated amount (fwd)
View as plain text  
On Wed, 1999-09-15 18:06:56 -0500, Manuel Coral A. impatiently wrote
again:
> can someone tell me if is posible one query to  get this.?
[...]
> mysql> select <some special options> from transactions;
> +--------+---------+---------------+
> | code   | country | total         |
> +--------+---------+---------------+
> | 000007 | BO      |    1.0000     |
> | 000001 | CL      |    2.0000     |
> | 000008 | BO      |    3.0000     | 
> | 000006 | BS      |    4.0000     |
> | 000005 | BS      |    5.0000     |
> | Total  |         |   15.0000     |
> +--------+---------+---------------+
> 6 rows in set (0.00 sec)

No, it's not possible.

(Actually, yes, nearly everything is possible -- it's comuters!  But I
won't make the same mistake again to post some it's-possible-but-you-
don't-want-to-actually-use-it method, because then still somebody is
going to copy it without any reflection ...)

Regards,
  Martin
-- 
Martin Ramsch <m.ramsch@stripped> <URL: http://home.pages.de/~ramsch/ >
PGP KeyID=0xE8EF4F75 FiPr=52 44 5E F3 B0 B1 38 26  E4 EC 80 58 7B 31 3A D7
Thread
acumulated amount (fwd)Manuel Coral A.16 Sep
  • Re: acumulated amount (fwd)Martin Ramsch17 Sep