Where condition to remove duplicate rows [message #633116] |
Wed, 11 February 2015 03:07 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/9996a32bf69a26d576c355127fae6a6d?s=64&d=mm&r=g) |
amjad_alahdal
Messages: 102 Registered: October 2013 Location: Saudi Arabia
|
Senior Member |
|
|
Hello,
I have Table_1
select * from table_1 ;
number: ****** Name:
1 AA
1 BB
2 CC
3 DD
5 FF
6 DD
6 UU
8 FF
9 SD
9 SS
what is the where condition I need to add to remove any duplicate rows, in the example, I want the select statement to give me the following:
2 CC
3 DD
5 FF
8 FF
you can see that 1,1,6,6,9,9 are removed.
How can I do that
|
|
|
|
|