View Single Post
  #1 (permalink)  
Old February 1st, 2004, 04:44 AM
qwjunk qwjunk is offline
Authorized User
 
Join Date: Jan 2004
Location: , , .
Posts: 24
Thanks: 0
Thanked 0 Times in 0 Posts
Default deleting only 1 duplicate entry

ive two duplicate entries in my db .. now i want to delete only one of them preferably the second occurance only .. how do i do that using sql ?

when i use the normal sql ie. DELETE .. WHERE FileID=required ID

it deletes both occurences .. how do i fix this .. ?

Reply With Quote