求人不如求己通过本文主要向大家介绍了mysql等相关知识,希望本文的分享对您有所帮助
CREATE TABLE `transaction` (
`t_id` int(11) NOT NULL AUTO_INCREMENT,
`buyer` varchar(20) DEFAULT NULL,
`seller` varchar(20) DEFAULT NULL,
`amount` decimal(8,2) DEFAULT NULL,
`start_time` datetime DEFAULT NULL,
`end_time` datetime DEFAULT NULL,
`createtime` datetime DEFAULT NULL,
PRIMARY KEY (`t_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
insert
insert into `transaction`(`t_id`,`buyer`,`seller`,`amount`,`start_time`,`end_time`,`createtime`) values (1,'张三1','李四1','8.20','2017-09-01 13:59:04','2017-09-02 13:59:07','2017-09-01 13:59:11'),(2,'张三2','李四2','6.20','2017-08-01 13:59:04','2017-08-02 13:59:07','2017-08-01 13:59:04'),(3,'王五1','李四2','3.20','2017-08-08 13:59:04','2017-08-13 13:59:07','2017-08-08 13:59:04'),(4,'麻子1','李四2','2.20','2017-08-16 13:59:04','2017-08-18 13:59:07','2017-08-16 13:59:04');
参考sql
SELECT *
FROM TRANSACTION
GROUP BY t_id, seller
HAVING seller='李四2' AND createtime <= '2017-08-15 13:59:04'