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
19071 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

Does a specific recovery model need to be used for a replicated database? : sql server replication

918

What is transaction server isolation?

978

What are the different types of sub-queries?

997

What is star, snowflake and star flake schema? : sql server analysis services, ssas

1090

What program is used to store the data source file?

910

What is bcp? When does it used?

924

Define clusters?

1000

Explain error and transaction handling in sql server?

956

in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it

1455

What to check if a User database is locked?

1021

What does it mean to normalize data?

898

tell me what is blocking and how would you troubleshoot it? : Sql server database administration

848

How can we delete a table in sql server?

928

Explain transaction server auto commit?

990

Are null values the same as that of zero or a blank space?

987