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 to use go command in "sqlcmd"?
What is nolock?
can an order by clause be used in a creation of a view?
What is attribute hierarchy? : sql server analysis services, ssas
How you can move data or databases between servers and databases in sql server?
Do you know exporting and importing utility?
How do you check sql server is up and running?
you have separate development and production systems you want to move a copy of a development database into production to do this, you do a backup on the development system and restore to the production system after a few minutes, you begin getting calls from several customers saying that they are denied access to the system why? : Sql server administration
Do you know spatial data types - geometry and geography in sql server 2008?
whats the maximum size of view state??
Differentiate sql server reporting services vs. Crystal reports?
Will sql server 2005 allow you to reduce the size of a column?
Explain what is “asynchronous” communication in sql server service broker?
Is sql different from sql server?
Difference between primary key and clustered index?