WITH T1 AS ( SELECT ROW_NUMBER () OVER ( PARTITION BY EmpId ORDER BY Emp

I have a table EMP in which the values will be like this

EmpId Ename Sal DeptId
11 Ram 10000 10
11 Ram 10000 10
22 Raj 20000 20
22 Raj 20000 20
33 Anil 15000 30
33 Anil 15000 30

I want to delete only duplicate Rows. After Delete I want
the output like this

EmpId Ename Sal DeptId
11 Ram 10000 10
22 Raj 20000 20
33 Anil 15000 30

Question Posted / guest

13 Answers
19552 Views
DELL, I also Faced
E-Mail Answers

Answer Posted / guest

WITH T1 AS (
SELECT ROW_NUMBER () OVER ( PARTITION BY EmpId ORDER BY
EmpId) AS RNUM,EmpId FROM EMP)
delete
FROM T1 WHERE RNUM > 1

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram

2017

Are semicolons required at the end of sql statements in sql server 2005?

996

What it means to be triggered?

1015

What is Extended user-defined?

965

What are group functions in query statements in ms sql server?

1013

How can we check the sql server version?

1076

How will you optimize a stored procedure optimization?

1047

Tell me what is sql profiler?

1037

What xml support does the sql server extend?

1020

How do I start sql server agent automatically?

976

What are the two modes of authentication in sql server?

1075

How can we improve performance by using SQL Server profiler?

1058

How to copy data from one table to another table?

999

What is the difference between SQL notification and SQL invalidation?

1198

ow to bring suspect mode datbase online from scratch

1810