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 bit data type?

0 Answers  

Can you explain what are the restrictions applicable while creating views? : SQL Server Architecture

0 Answers  

Why we use the openxml clause?

0 Answers  

What do mean by xml datatype?

0 Answers  

What does the not null constraint do?

0 Answers  

How maney row would be print after join if A table have 100 rows and B table have 50 rows...

9 Answers   Hewitt,

what is database replicaion? What are the different types of replication you can set up in sql server? : Sql server database administration

0 Answers  

What is always encrypted?

0 Answers  

What is ms sql server triggers?

0 Answers  

What is the diff between Static Queries and Dynamic queries give me some examples

2 Answers   CSC,

What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?

0 Answers   Accenture,

Call by value and call by reference in procedure and function, with NOCOPY.

0 Answers   Nagarro,

For more SQL Server Interview Questions Click Here
Categories