打开重复记录的所有字段值并获取离当前时间最近的记录
方法一:
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 (ident...
2012-07-24 13:08:02 ·
106 阅读 ·
0 评论