Click here to Skip to main content
15,882,063 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more: , +
I have a Table name "fileupload" having some 4000 records.There are 2 column("uploadcount","createcount") without primary key.

ALL are duplicate.
I want to delete all records except first / I want to keep only one record and delete rest.

can anybody suggest sql query for that ?


Thanks you all
Regards
Asutosha
Posted

1 solution

 
Share this answer
 
v2
Comments
Suresh Suthar 15-Sep-11 1:11am    
Nice links. 5!
Prerak Patel 15-Sep-11 1:23am    
Thanks Suresh :)

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900