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
- 10283 Views
- I also Faced
- E-Mail Answers
Answer Posted / ambarish
we can use cursor.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain indexing and what are the advantages of it?
What do you understand by triggers and mention the different types of it?
What happens to a trigger with multiple affected rows?
How do you make a trace?
How to choose all records from the table?
Recommend an approach to ensuring that all changes in the remote databases synchronize with the SQL Azure database?
What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?
what is create database syntax? : Sql server database administration
What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?
What are the different types of stored procedures?
What is a trigger and types of a trigger?
If any stored procedure is encrypted, then can we see its definition in activity monitor?
What are the differences between having and where clause.
Explain the dbcc pintable command when would you use it?
What do you understand by a view? What does the with check option clause for a view do?
