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 instead of dml trigger?

0 Answers  

What is logon trigger?

0 Answers  

What options are available to audit login activity? : sql server security

0 Answers  

Explain about unique identifier data type in sql server?

0 Answers  

List some case manipulation functions in sql?

0 Answers  

Can I remove the default constraint columns in SQL SERVER?

5 Answers   Value Labs,

how to do partition in sqlserver

0 Answers   TCS,

how to replace double quotes by single quotes in sql server

2 Answers   CAC,

Difference between rowid and rownum in SQL?

1 Answers   Virtusa,

what is the difference between openrowset and openquery?

0 Answers  

What is the difference between local and global temporary tables?

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,

For more SQL Server Interview Questions Click Here
Categories