如何删除重复值...？ [英] how to remove the duplicate values...?

问题描述

我有一个包含超过15列的表，因为只有两列具有重复值，我想根据这两列来删除重复值...



源数据（从评论中复制）

I have one table that contain more than 15 columns,in that only two column having repeated values i want to dlete that repeated value based on that two columns...

Source data (copied from comments)

name srno rowid subfrom subto
ash 1 1 sa01 sa02
ash 1 2 sa01 sa03
ash 1 3 sa01 sa43
ash 1 4 sa01 sa02
ash 1 5 sa01 sa07
ash 1 6 sa01 sa02
raj 1 1 sa02 sa17
raj 1 2 sa02 sa89
raj 1 3 sa02 sa17
raj 1 4 sa02 sa02
raj 1 5 sa02 sa90
raj 1 6 sa02 sa89

推荐答案

如果你正在使用Oracle，那么使用rowid来区分它们。

IF U are using Oracle then use rowid for distinguishing them.

这篇关于如何删除重复值...？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！