您可以选择保留 rowid 分组的 min 或 max通过显示的 3 列.

You can choose to keep the min or max of rowid grouping by the 3 columns shown.

delete from myTable
where rowid not in (select min(rowid)
                    from myTable
                    group by name,company,position)