|
>> >> | 32.43 | 230.43305176 |
>> >> | 3 | 233.43305176 |
>> >> +-+--+
>> >> 3 rows in set (0.00 sec)
>> >>
>> >>
>> >> Good luck!
>> >>
>> >>
10
>> >> > 2 20
>> >> > 3 30
>> >> > 4 40
>> >> > 5 50
>> >> >
>> >> > it would return
>> >> >
>> >> > 1 10
>> >> > 2 20
>> >&
gt;> > 4 40
>> > 5 50
>> >
>> > it would return
>> >
>> > 1 10
>> > 2 20
>> > 3 30
>> > 4 40
>> >
>> > (sum total = 100)
>> >
>> > but if your table was
>> >
>
2 20
>> > 3 30
>> > 4 40
>> > 5 50
>> >
>> > it would return
>> >
>> > 1 10
>> > 2 20
>> > 3 30
>> > 4 40
>> >
>> > (sum total = 100)
>> >
>> > but if yo
ves
>> Virginia Tech Information Technology
>> 1700 Pratt Drive
>> Blacksburg, VA 24060
>>
>> Email: [EMAIL PROTECTED]
>> Phone: (540) 231-4396
>>
>> -Original Message-
>> From: Ahmad Al-Twaijiry [mailto:[EMAIL PROTECTED]
>> Sen
doesn't work :( , tested with 4.1.21
On 21 Sep 2006 13:20:37 -, Felix Geerinckx
<[EMAIL PROTECTED]> wrote:
On 18/09/2006, "Ahmad Al-Twaijiry" wrote:
> I want to run SQL query that will return to me the first records that
> the SUM of Total field = 100
USE test;
DROP TABLE IF EXISTS foo;
CR
t;
> Using only SQL, your best bet would be a stored procedure,
> otherwise its really application logic to select the rows one at a
> time and keep a running total.
>
> HTH
>
> Quentin
>
> -Original Message-----
> From: Ahmad Al-Twaijiry [mailto:[EMAIL PROTECT
On 18/09/2006, "Ahmad Al-Twaijiry" wrote:
> I want to run SQL query that will return to me the first records that
> the SUM of Total field = 100
USE test;
DROP TABLE IF EXISTS foo;
CREATE TABLE foo (
id INT UNSIGNED NOT NULL PRIMARY KEY, total INT NOT NULL);
INSERT INTO foo VALUES
(1, 20), (2,
ginal Message-
From: Ahmad Al-Twaijiry [mailto:[EMAIL PROTECTED]
Sent: Wednesday, 20 September 2006 2:24 a.m.
To: Price, Randall
Cc: Edward Macnaghten; mysql@lists.mysql.com
Subject: Re: SUM in WHERE
Actually is this possible with simple SQL command in Mysql ?
On 9/19/06, Price, Randall <[EMAIL
--Original Message-
From: Ahmad Al-Twaijiry [mailto:[EMAIL PROTECTED]
Sent: Wednesday, 20 September 2006 2:24 a.m.
To: Price, Randall
Cc: Edward Macnaghten; mysql@lists.mysql.com
Subject: Re: SUM in WHERE
Actually is this possible with simple SQL command in Mysql ?
On 9/19/06, Price, Randall <[EM
Information Technology
1700 Pratt Drive
Blacksburg, VA 24060
Email: [EMAIL PROTECTED]
Phone: (540) 231-4396
-Original Message-
From: Ahmad Al-Twaijiry [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 19, 2006 10:06 AM
To: Edward Macnaghten
Cc: mysql@lists.mysql.com
Subject: Re: SUM
ginal Message-
From: Ahmad Al-Twaijiry [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 19, 2006 10:06 AM
To: Edward Macnaghten
Cc: mysql@lists.mysql.com
Subject: Re: SUM in WHERE
I tried it also with 4.1.21-log and still didn't work !
On 9/19/06, Ahmad Al-Twaijiry <[EMAIL PROTECTED
I tried it also with 4.1.21-log and still didn't work !
On 9/19/06, Ahmad Al-Twaijiry <[EMAIL PROTECTED]> wrote:
I tried that before and it also doesn't work, is it because I'm using
mysql version 4.1.19 ?
On 9/19/06, Edward Macnaghten <[EMAIL PROTECTED]> wrote:
> Ahmad Al-Twaijiry wrote:
>
> >
I tried that before and it also doesn't work, is it because I'm using
mysql version 4.1.19 ?
On 9/19/06, Edward Macnaghten <[EMAIL PROTECTED]> wrote:
Ahmad Al-Twaijiry wrote:
> Hi everyone
>
> SELECT * FROM tbl_name WHERE SUM(Total)=100 ORDER BY ID
>
>
SELECT ID FROM tbl_name GROUP BY ID HA
Ahmad Al-Twaijiry wrote:
Hi everyone
SELECT * FROM tbl_name WHERE SUM(Total)=100 ORDER BY ID
SELECT ID FROM tbl_name GROUP BY ID HAVING SUM(Total)=100 ORDER BY ID
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[E
Hi
I would expect the following result :
[ ID ][ Total ]
[ 1 ][ 20 ]
[ 2 ][ 30 ]
[ 3 ][ 40 ]
[ 4 ][ 10 ]
because if you SUM(Total) in the result you will see it = 100
On 9/19/06, André Hänsel <[EMAIL PROTECTED]> wrote:
> -Ursprüngliche Nachricht-
> Von: Ah
16 matches
Mail list logo
