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...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

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

Question Posted / dilip

Answer Posted / dilip

Ans for 1st Query
How to retrieve duplicate rows in a table?

SELECT * FROM EMP1 WHERE (EMP_ID IN (SELECT emp_id FROM
emp1 GROUP BY emp_id HAVING COUNT(emp_id) > 1))

Is This Answer Correct ?    12 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What language is sql server written in?

985

What is the full form of ddl?

864

What is open database communication (odbc)?

1003

What is the difference between varchar and nvarchar?

897

Can we call stored procedure in view in sql server?

860

What does top operator do?

963

How to add code to the existing article (using improve article)?

1046

Explain acid?

1017

Explain what are page splits? : SQL Server Architecture

1003

Why is the need for data conversion transformations?

978

How do you use a subquery to find records that exist in one table and do not exist in another?

991

What are the limitations in ssrs on sql server express edition?

175

What is the difference between functions and stored procedures?

1091

What is entity data services?

1003

What is primary key and example?

896