方法一:
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 )
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 )