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"
To: "HaidarPesebe" ; "MySQL Lists"
Se
Thanks Mr. Wang,
I will try and inform you again if have a problem.
Best regard,
Haidar Pesebe
- Original Message -
From: "Yang Wang"
To: "HaidarPesebe" ; "MySQL Lists"
Sent: Monday, December 21, 2009 5:22 PM
Subject: Re: Most data sort
sample as
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:
