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 are some examples of schemas?

0 Answers  

explain the type of contraints

3 Answers  

what are the advanced features in sql 2008?

2 Answers   Wipro,

What is change tracking in sql server?

0 Answers  

What is the server name in sql server?

0 Answers  

Can anybody explain me cold backup and hot backup?

3 Answers   TCS,

Can we rewrite subqueries into simple select statements or with joins? Example?

2 Answers   ASD Lab,

What is the difference between a Application Server and a Database

3 Answers   Oracle,

What is the difference between the 2 operating modes of database mirroring?

0 Answers  

Explain view in sql server?

0 Answers  

What is meant by indexing files?

0 Answers  

what is blocking? : Sql server database administration

0 Answers  

For more SQL Server Interview Questions Click Here
Categories