Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

How to retrieve duplicate rows in a table?
How to delete the duplicate entries in a table?

Answer Posted / pawan k. dubey

delete from employee
where Emp_id not in (select min(Emp_id) from employee
group by Emp_Name)

Is This Answer Correct ?    2 Yes 12 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is resultset an interface?

1040


Tell me what is de-normalization and what are some of the examples of it?

1100


What do you mean by data manipulation language?

1065


Are resultset updatable?

1010


after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?

2143


How to concatenate two character strings together?

1170


What is the difference between implicit and explicit transaction?

1054


How many levels of sp nesting are possible?

1071


What is dknf in normalization form?

1116


What is the minimum and maximum number of partitions required for a measure group? : sql server analysis services, ssas

1107


How do I start sql server 2016?

954


What are the advantages of mirroring?

1046


What are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture

1059


What is index, cluster index and nonclustered index?

1051


What is the difference between writing data to mirrored drives versus raid5 drives

990