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
- 10304 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
What is the difference between varchar and nvarchar datatypes?
Relational calculus is what type of language?
What is the difference between join and inner join?
Are semicolons required at the end of sql statements in sql server 2005?
What are the kinds of subquery?
Define indexes?
What is the difference between composite index and covering index?
What action plan is preferred if sql server is not responding?
how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }
How to replace the Query Result 'Null Value' with a text ?
Can a unique index be created on a column, which contains null?
Every night you run a full backup after every 3 three hours you make a differential backup every hour you make an incremental backup in a worst-case scenario, how much work you can lose?
What is "scheduled jobs" or "scheduled tasks"?
How many clustered indexes can be created on a table? I create a separate index on each column of a table. what are the advantages and disadvantages of this approach?
Is the order of columns in the set clause important in ms sql server?
