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 delete duplicate record from a particular table?

Question Posted / durga prasad.g

Answers were Sorted based on User's Feedback



How To delete duplicate record from a particular table?..

Answer / deepa

For Example

sno names
1 arun
2 arun
3 arun
6 arun
7 bala
11 bala
12 guna
9 guna
14 guna
10 raj
13 raj

Table Name T1
Fields Names Sno,Names

Delete From t1 where sno not in
(select min(sno) from t1 group by names)

Is This Answer Correct ?    2 Yes 5 No

How To delete duplicate record from a particular table?..

Answer / parashu

Delete from <TableName> where <fieldName> in (select
<FieldName> from <TableName> Group By <FieldName> Having
(Count(<FieldName>)>1))

Is This Answer Correct ?    0 Yes 8 No

Post New Answer

More SQL Server Interview Questions

What is resultset concur_updatable?

0 Answers  

How do you create a data source?

0 Answers  

write a query to remove duplicate records without using primary key column?

2 Answers   ABCO,

What is compression - row-level and page-level compression?

0 Answers  

What is side by side migration in sql server?

0 Answers  

Explain different types of self contained sub query?

0 Answers  

How many types of Outer Joins?What are they?

1 Answers  

What is relationship? What number of sorts of relationship are there?

0 Answers  

What is function of CUBE ?

0 Answers   HCL,

explain query execution plan

1 Answers  

Define the one-to-one relationship while designing tables.

0 Answers  

Do you know what are different types of replication in sql server?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories