Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to delete duplicate records in SQL SERVER
- 36 Answers
- 76652 Views
- Infosys, I also Faced
- E-Mail Answers
Answer Posted / kalyan
with [TN ordered by CN] as
(
select row_number() over(partition by CN order by CN) as
rowid,* from TN
)
delete from [TN ordered by CN] where rowid > 1
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
Do you know what is sql injection?
What is a Join and explain its types?
How many columns can we include on clustered index ?
Name few of the dcl commands in sql?
What is the difference between an index and a unique index?
your distribution database is full what will u do
List out different types of normalizations in sql server and explain each of them?
Differentiate between sql temp table vs table variable?
Explain difference between cross join and full outer join?
Explain the third normal form(3nf)?
Delete duplicate rows without using rowid.
What is the difference between having clause and where clause in sql server?
What happens if null values are involved in string operations?
What are different types of schemas?
How to transfer data from a cursor to variables with a "fetch" statement?
