 | |
determine there are duplicate rows?
comp.databases.olap comp.databases.olap
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
determine there are duplicate rows? -
09-07-2006
, 02:58 PM
#2
| |||
| |||
|
|
Hello Guys I have a problem There are 4 columns in a table(c1,c2,c3,c4)..c1 and c2 being the keys.How will you determine there are duplicate rows? It has to be done in Pl/SQL. I am not sure how to do it. Is there a particular command to do it ! HElp me please Thanks Nitin Create the PK constraint and let the database handle it. |
#3
| |||
| |||
|
|
Hello Guys I have a problem There are 4 columns in a table(c1,c2,c3,c4)..c1 and c2 being the keys.How will you determine there are duplicate rows? It has to be done in Pl/SQL. I am not sure how to do it. Is there a particular command to do it ! HElp me please Thanks Nitin Create the PK constraint and let the database handle it. -------------------------------------------------------------------------------------------------- |
Select feild1(the field you have duplicate) from table1
Group by field1 (same field)
Having count(*) > 1
I think so u want to identify duplicte records the above will work.
Cheers
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.