Interested to Buy Any Domain ? << Click Here >> for more details...
How To delete duplicate record from a particular table?
- 12 Answers
- 25365 Views
- eXensys, Foxfire, I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
If you are given access to a SQL Server, how do you find if the SQL Instance is a named instance or a default instance?
How to assign new column names in a view?
how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }
How do I find sql server instance name?
Explain what is it unwise to create wide clustered index keys?
What is scalar user-defined function?
What are the different acid properties?
Can you edit the .rdl code associated with a linked report?
What is a transaction and why is it important?
What is sql view?
Do you know what are the ways available in sql server to execute sql statements?
what is a mixed extent? : Sql server administration
What are the rendering extensions of ssrs?
Do you know what is difference between index seek vs. Index scan?
Do you know what are different types of replication in sql server?
