Thread
:
deleting only 1 duplicate entry
View Single Post
#
2
(
permalink
)
February 2nd, 2004, 01:15 AM
ankur_vachhani
Authorized User
Join Date: Jan 2004
Location: Pune, MAHARASHTRA, India.
Posts: 16
Thanks: 0
Thanked 0 Times in 0 Posts
use this sql query to delete only one duplicate record
delete from your_table where rowid in
( select min(rowid) from your_table where FileID = your_requiredID)
HTH
ankur_vachhani
View Public Profile
Visit ankur_vachhani's homepage!
Find all posts by ankur_vachhani