Interested to Buy Any Domain ? << Click Here >> for more details...
in tabase table having a column in it empname field is
there which having 5 duplicate values is there i want
deleted all the duplicates i want showing only one name
only.
- 7 Answers
- 10264 Views
- I also Faced
- E-Mail Answers
Answer Posted / venkat
Hope this methodology would help you better
1.Create a temp table
2.Select duplicated row's empid,empname into the temp table.
3.Create a cursor by selecting values from temp table.
4.Keep either min or max(empid) from original table and
delete the rest of the duplicated rows.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Define right outer join?
What are the benefits of normalization?
What are acid properties of transaction?
What are translations and its use? : sql server analysis services, ssas
Explain what is log shipping?
How is SQL Azure different than SQL server?
How to use old values to define new values in update statements in ms sql server?
How to update muliple row in single query?
What are the lambda triggers?
Can we install sql server 2016 on windows 7?
What is the optimal disk configuration for a database server and what raid configurations would you use if budget is not a constraint?
What is user defined datatypes and when you should go for them?
What is sql server query analyzer?
Explain what is “asynchronous” communication in sql server service broker?
What is the report builder?
