复制

#可以使用如下SQL语句实现：

SELECT *
FROM table_name
ORER BY display_order DESC, id DESC;


// 其中，`table_name`是要查询的表名，
// `display_order`是按照该字段倒序排序，
// `id`是按照该字段倒序排序。
// 如果`display_order`相同，则按照`id`倒序排序。

复制

delete from xs_lxdj where (xh,xqdm,type,time) in (
   select * from (
   select n.xh,n.xqdm,n.type,n.time from xs_lxdj n group by n.xh,n.xqdm,n.type,n.time having count(n.id)>1
    ) a
            )
and id not in (
select * from (
select min(m.id) from xs_lxdj m group by m.xh,m.xqdm,m.type,m.time having count(m.id)>1
                                                                   ) b
)