|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
You don't need a fax machine to get faxes. Get a fax-to-email fax number from CallWave. Try it free.
|
|
#1
May 18th, 2004, 11:03 PM
|
|||
|
|||
|
About Delete Statement
I have some selfsame record in table. But just i need one of all, So I delete other record . Can someone help me with SQL Statement solve this problem !!! Thanks !!!
|
|
#2
May 19th, 2004, 12:46 AM
|
|||
|
|||
|
I don't understand what you're asking
 Can you post an example of the table data and what you'd want in your solution?
|
|
#3
May 19th, 2004, 08:42 AM
|
||||
|
||||
|
null, it's the age-old dupes problem
which arises from the indiscrimnate use of auto_increment or identity primary keys combined with a failure to declare a unique index on the "real" key thus, someone will end up with this -- 314 mary smith 315 tom brown 316 fred floop 317 tom brown 318 bill butt 319 ohmy lord "But just i need one of all, So I delete other record" what this means is, they want to delete all but one of the dupes dupeng, which one do you want to keep? the one with the lowest id?
|
|
#4
May 19th, 2004, 05:12 PM
|
|||
|
|||
|
Ah ok...makes sense now, I've had to clean up scenarious like this many times. Thx r937.
|
|
| Viewing: Dev Shed Forums > Databases > MS SQL Development > About Delete Statement |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
 |
|
|
 |
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
