Delete duplicate records from the table?(Table must have
unique id)
Answer Posted / krishna
select *
from mytable b
join
(
select Duplicatecolumn,MAX(id) id
from mytable
group by Duplicatecolumn
) b1 on b.Duplicatecolumn = b1.Duplicatecolumn
where b.id <> b1.id
Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Explain microsoft sql server functions?
What are the differences between ms sql server & oracle?
Give an example of why you would want to denormalize a database
Data table as parameter in sql server?
i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.
What are the acid properties?
What is cte (common table expression)?
Define msdb database?
What is coalesce and check constraint in sql server?
Why are sql functions used?
How does index makes search faster?
what are different types of backups available in sql server? : Sql server database administration
What authentication modes does sql server support?
What are the steps you will take to improve the performance of a poor performing query?
Explain filtered indexes benefits?