Hi,
you can do it by using temporary table.
create table #temp (Sno int, Name varchar(50), City varchar(50))
insert into #temp select * from Maintable
delete from Maintable
insert into Maintable select distinct * from #Temp
select * from Maintable
drop table #temp
Regards,
Prakash.T