List:General Discussion« Previous MessageNext Message »
From:HaidarPesebe Date:December 21 2009 10:46am
Subject:Re: Most data sort
View as plain text  
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
>
>
> 

Thread
Most data sortHaidarPesebe21 Dec
  • Re: Most data sortYang Wang21 Dec
  • Re: Most data sortHaidarPesebe21 Dec
Re: Most data sortHaidarPesebe21 Dec