How To delete duplicate record from a particular table?

Question Posted / durga prasad.g

12 Answers
24499 Views
eXensys, Foxfire, I also Faced
E-Mail Answers

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

How you can find out if an index is useful to the optimizer?

0 Answers

What is data source document?

0 Answers

how would you troubleshoot blocking? : Sql server database administration

0 Answers

How many nested transaction can possible in sql server?

3 Answers Bank Of America,

About types of indexes in SQL server ?

2 Answers Cognizant,

Suppose in a situation if two list boxes are there and if you select multiple options based on that the options related to those selected items should display in second list box. Again if we select multiple items in second listbox then the related to those selected items should display . In this scenario how will you design database,tables?

1 Answers HP,

write sql program to get the detail of student in a class?

2 Answers

If any possiable to use 2 primary key in single table? How many primary key & foreign key used in each table(min & max)?

3 Answers

how to take backup bcp out for a column in table in sql server?

0 Answers

Does the order of columns in update statements matter?

0 Answers

How to Get the last identity value used

4 Answers

Is sql server is free?