SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how to select rows with duplicate column values

470436Nov 21 2005 — edited Mar 29 2006

hi,

i have a table property_details which has these 2 columns customerno and propertyno a customer can have many properties and property number has to be unique. but somehow these property number has been duplicated at an earlier stage so i have for a customer with many properties the same property number
how i will select such records whose asset numbers are the same

for ex
customer no property no
a1300 1
a1300 1
a1300 1
a2330 10
a2330 10
a2330 10

kindly suggest me a solution

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 26 2006

Added on Nov 21 2005

8 comments

6,648 views