数据库中group by和having语法使用详解(二)

database if not exists `phone_deal`;

USE `phone_deal`;

DROP TABLE IF EXISTS `deal`;

CREATE TABLE `deal` (

`sell_no` varchar(100) NOT NULL,

`name` varchar(100) default NULL,

`phone` varchar(100) default NULL,

`amount` decimal(10,0) default NULL,

`date` datetime default NULL,

PRIMARY KEY (`sell_no`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

insert into `deal`(`sell_no`,`name`,`phone`,`amount`,`date`) values ('00001','李晓红','15822533496','60','2011-10-23 08:09:23'),('00002','李晓红','15822533496','50','2011-10-24 08:15:34'),('00003','李晓红','15822533496','40','2011-10-24 12:20:56'),('00004','杨轩','18210607179','100','2011-10-24 07:59:43'),('00005','杨轩','18210607179','50','2011-10-24 10:11:11'),('00006','柳梦璃','15822533492','1000','2011-10-24 09:09:46'),('00007','韩菱纱','15822533493','10000','2011-10-24 08:09:45'),('00008','云天河','15822533494','500','2011-10-24 08:09:25');