Dear Mr. Wang,
I've tried and the results are in accordance with the intended.
Your description is very brief and precise
Thank you Mr. Wang.
With best regard,
Haidar Pesebe
----- Original Message -----
From: "HaidarPesebe" <haidarpesebe@stripped>
To: "Yang Wang" <ywang@stripped>; "MySQL Lists"
<mysql@stripped>
Sent: Monday, December 21, 2009 5:29 PM
Subject: Re: Most data sort
> Thanks Mr. Wang,
> I will try and inform you again if have a problem.
>
> Best regard,
> Haidar Pesebe
>
>
> ----- Original Message -----
> From: "Yang Wang" <ywang@stripped>
> To: "HaidarPesebe" <haidarpesebe@stripped>; "MySQL Lists"
> <mysql@stripped>
> Sent: Monday, December 21, 2009 5:22 PM
> Subject: Re: Most data sort
>
>
>> sample as below with group by and order by statment
>>
>>
>> mysql> create table t2(name char(1),qty smallint);
>> Query OK, 0 rows affected (0.01 sec)
>>
>> mysql> insert into t2
>>
> values('A',1),('B',2),('A',4),('A',1),('A',1),('B',1),('A',2),('C',2),('D',1),('C',4);
>> Query OK, 10 rows affected (0.00 sec)
>> Records: 10 Duplicates: 0 Warnings: 0
>>
>> mysql> select * from t2;
>> +------+------+
>> | name | qty |
>> +------+------+
>> | A | 1 |
>> | B | 2 |
>> | A | 4 |
>> | A | 1 |
>> | A | 1 |
>> | B | 1 |
>> | A | 2 |
>> | C | 2 |
>> | D | 1 |
>> | C | 4 |
>> +------+------+
>> 10 rows in set (0.00 sec)
>>
>> mysql> select name,sum(qty) as qty from t2 group by name order by qty
>> desc;
>> +------+------+
>> | name | qty |
>> +------+------+
>> | A | 9 |
>> | C | 6 |
>> | B | 3 |
>> | D | 1 |
>> +------+------+
>> 4 rows in set (0.01 sec)
>>
>>
>>
>>
>> Best Regards!
>> Yang Wang
>>
>>
>> ----- Original Message -----
>> From: "HaidarPesebe" <haidarpesebe@stripped>
>> To: "MySQL Lists" <mysql@stripped>
>> Sent: Monday, December 21, 2009 3:31 PM
>> Subject: Most data sort
>>
>>
>> Dear All,
>>
>> I need your help to how to call the database.
>>
>> I've got a mysql database as follows:
>> ------------------
>> Name | qty
>> -----------------
>> A 1
>> B 2
>> A 4
>> A 1
>> B 1
>> A 2
>> C 2
>> D 1
>> C 4
>>
>> How calling if I want to sort the data according to the most, or the
>> result will look like this
>>
>> A = 7
>> C = 6
>> B = 3
>> D = 1
>>
>> Thanks a lot
>> Haidarpesebe
>
>
> __________ Information from ESET Smart Security, version of virus
> signature database 4704 (20091220) __________
>
> The message was checked by ESET Smart Security.
>
> http://www.eset.com
>
>
>
