How to delete duplicate records from a table?(for suppose in
a table we have 1000 Records in that we have 200 duplicate
Records , so ,how to findout that duplicate Records , how to
delete those Records and arranged into sequence order? one
more thing that there is no primary key at all)
- 5 Answers
- 9098 Views
- Infosys, McAfee, I also Faced
- E-Mail Answers
Answer Posted / sirisha
with numbered as(select rowno = row_number() over(partition
by empid order by empid),empname from employee)delete from
numbered where rowno > 1
| Is This Answer Correct ? | 1 Yes | 6 No |
Post New Answer View All Answers
What are two difference between sql azure and azure tables?
Can sql server be linked with other servers like oracle?
What is explicit mode in sql server?
Tell me the difference between clustered and non-clustered index?
What is the difference between join and inner join?
How to configure and test odbc dsn settings?
Which is better statement or preparedstatement?
What happens if you are trying to access a schema not owned by you?
How do you delete a data source?
What is dknf in normalization form?
Do you know what is difference between stored procedure and user defined function?
Which sql server table is used to hold the stored procedure script?
what is the maximum size of a row? : Sql server database administration
Why we should not use triggers?
How to select all columns of all rows from a table with a select statement in ms sql server?
