How To delete duplicate record from a particular table?
Answer Posted / arif jameel
ADD a new identity_column (1,1) on <table>
by
alter table <table_name>
add <Identity_column> int identity(1,1)
delete from <table> where <identity_Column> in
(select max(<identity_Column>) from <table>
group by any <table_column_name>)
drop <identity_column>
Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
When multiple after triggers are attached to sql table, how to control the order of execution?
How to get the definition of a view out of the sql server?
Are null values the same as that of zero or a blank space?
What are the benefits of normalization?
what type of index will get created after executing the above statement? : Sql server database administration
Write a code to select distinct records without using the DISTINCT keyword.
Does any body please help me what question's have asked for SSRS in the interview?
What are information schema views?
where the connection string store in the database
Write an sql query to sort a table according to the amounts in a row and find the second largest amount.
what is a mixed extent? : Sql server administration
What is normalization and denormalization in sql server?
How to convert numeric expression data types using the cast() function?
How is table type constraint applied to a table?
between cast and convert which function would you prefer and why?