|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
|
|
#1
June 27th, 2005, 02:38 PM
|
|||
|
|||
|
delete duplicate values of a coulmn
i have this table with multiple copies of the same row....how do i get rid of the duplicate rows and just keep the only one copy of that row.
|
|
#2
June 27th, 2005, 03:42 PM
|
||||
|
||||
|
Use this tip to get rid of duplicates, then set up a primary key or an unique index.
__________________
My blog about OpenSource Databases PDF tutorials about OSS databases, DBMonster ... Please contribute to Open Source Development, fill bug reports!!! Developer Shed eSupport Commented my.ini/my.cnf (PLEASE ADD YOUR OWN CONFIG TRICK) An introduction to database normalization Natural or Surrogate key Custom ordering for your results Correlated and uncorrelated subqueries Don't turn your outer joins into inner joins
|
|
#3
June 29th, 2005, 02:02 PM
|
|||
|
|||
|
thanks
thanks a lot... apppreciate for ur time
Quote:
|
|
| Viewing: Dev Shed Forums > Databases > Oracle Development > delete duplicate values of a coulmn |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
