Hello This way u can Delete Duplicate data from table. :)
First of all create table
1>create table tblmanu(Id int, Name varchar(50));
===
2>insert into tblmanu values(1,'Manu');
2>insert into tblmanu values(2,'Jhon');
3>insert into tblmanu values(3,'Manu');
==========
select * from tblmanu;
=======
find the number of duplicate data::::
select name, count(*) Totalcount from tblmanu group by name having count(*) >1 order by count(*) desc;
==================
delete from tblmanu where id not in(select max(id) from tblmanu group by name);
duplicate data will delete
===============
select * from tblmanu;
Manoranjan Gupta Manu
9873306227
Nandkishorre, if this helps please login to Mark As Answer. | Alert Moderator