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'