delete redundant data

[mkeerthi]

Hii,
I want to delete the redundant data in a table..Please help me with this.

[menocomp]

delete from Hotelimages where ImageID not in (
select MIN(ImageID) as Imageid
from HotelImages
group by URL
having count(*) >=1) as redantantData