打开重复记录的所有字段值并获取离当前时间最近的记录

方法一：
select o.* from zjx_order o where o.ordertime = (select max(ordertime) from zjx_order  group by identitycard having o.identitycard = identitycard )

方法二：
select * from zjx_order where (identitycard,ordertime) in(select identitycard,max(ordertime) from zjx_order group by identitycard )