mysql查询某个筛选条件下的n条多个分类数据的每个分类最新的数据

1.表结构/和表创建sql

CREATE TABLEtest_inquiry_record(idint(11) NOT NULL AUTO_INCREMENT,poster_idvarchar(30) NOT NULL COMMENT '挂单号',client_idvarchar(30) NOT NULL COMMENT '交易商id',pricedecimal(19,2) DEFAULT NULL COMMENT '报价',statusvarchar(1) NOT NULL COMMENT '询价状态',origin_record_idvarchar(30) NOT NULL COMMENT '询价单id',oper_timetimestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '操作时间',create_timetimestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '创建时间', PRIMARY KEY (id`)
) ENGINE=InnoDB AUTO_INCREMENT=59 DEFAULT CHARSET=utf8

2.查询要求

poster_id=h1的所有client_id的最新报价

3.查询语句

select * from test_inquiry_record
where create_time
in(select max(create_time) create_time from test_inquiry_record t
group by poster_id,client_id)
order by client_id;

4.结果展示