Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to delete duplicate records in SQL SERVER
- 36 Answers
- 76389 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
What is the difference between NOROW and LOCKROW?
where the connection string store in the database
Explain the architecture of ms sql reporting service?
Explain error handling in ssis?
What is triggers in ms sql server?
Explain important index characteristics?
What are wait types?
What is “asynchronous” communication in sql server service broker?
Give the query of getting last two records from the table in SQL SERVER?
Do you know what is a trace frag? Where do we use it?
What is sql server 2000 work load governor?
Mention the 3 ways to get a count of the number of records in a table.
What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?
What is use of except clause? How does it differ from not in clause?
Where cross join is used?
