Interested to Buy Any Domain ? << Click Here >> for more details...
How To delete duplicate record from a particular table?
- 12 Answers
- 24500 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
What is the maximum size of a dimension? : sql server analysis services, ssas
What are the different types of sql server replication? : sql server replication
How does clustered and non clustered index work?
What is etl - extraction, transformation, and loading?
What is row-level compre?
Do you know nested transaction?
What is indexing explain it with an example?
What are group functions in query statements in ms sql server?
What is a field in a table?
What are different types of subquery?
Give me any three differences between Truncate and Delete.
Explain what you mean by 3 tier architecture.
Which event (check constraints, foreign key, rule, trigger, primary key check) will be performed last for an integrity check?
Name 3 of the features that the sql server built-in function loginproperty performs on standard logins? : sql server security
What is the difference between web edition and business edition?
