Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to delete duplicate records in SQL SERVER
- 36 Answers
- 75358 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
How to turn on the mssql api module in php?
What is the difference between a primary key and a unique key? Are they the same?
What gets stored inside msdb database?
Which are the third-party tools used in sql server and why would you use them?
Explain transaction server isolation?
Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...
What is CTE in SQL
Can you explain what is the use of custom fields in report?
What is normalization of database?
Explain the Ways to improve the performance of a sql azure database?
Explain about remote stored procedure?
Define inner join in sql server joins?
How much memory that we are using in Logshipping Concept?
How many categories of data types used by sql server?
Explain what is the function of sql server agent windows service?
