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

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