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.
Answer Posted / ambarish
we can use cursor.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How do you open a cluster administrator?
How can windows applications connect to sql servers via odbc?
Define cursor locking
explain how to create a new schema in a database? : Sql server database administration
What are different backups available in sql server?
What is difference between inner join and full join?
How to execute multiple stored procedures at one time in sql server?
What is service broker?
you have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation? : Sql server administration
Difference between report and query parameter. Why do we need different type of parameter?
what is the difference between delete table and truncate table commands? : Sql server database administration
What are the properties of primary key?
What is built-in/administrator?
what is a major difference between sql server 6.5 and 7.0 platform wise? : Sql server database administration
What is a transact-sql statement?