rowid:唯一标识记录的物理地址,真实存在,不会改变
rowid:在更新;查找,删除重复记录时,经常使用
一.查找
1、查找有重复数据的记录(使用count来统计)
select empno from emp_tmp group by empno having count(*)>1;
select * from emp_tmp a where a.empno in
(select empno from emp_tmp group by empno having count(*)>1);
2、对有重复数据的记录去重(类似:distinct)
select * from emp_tmp a where a.rowid in (select max(rowid) from emp_tmp group by empno) ;
3、查找有重复数据的记录(使用max(rowid)):每个重复数据只显示(n-1)个
select * from emp_tmp a where a.rowid not in (select max(rowid)