mysql、sqlserver等可以采用主键自动生成策略;
oracle使用sequence;
如果rowid只针对oracle的话:
rowid是代表的是记录的物理地址
如果你需要的是删除数据库中的数据:delete from table a
where (a.user_id,a.tw_id) in (select user_id,tw_id from vitae group by user_id,tw_id having count(*) >1)
and rowid not in (select min(rowid) from vitae group by user_id,tw_id having count(*)>1)
如果只是查出是去重:
select distinct user_id,tw_id from table
欢迎分享,转载请注明来源:内存溢出
评论列表(0条)