SET rowcount 3 delete distinct * from table set rowcount 0 select

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 / ashim kumar pal

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

Answer Posted / ashim kumar pal

SET rowcount 3

delete distinct * from table

set rowcount 0

select * from table

Is This Answer Correct ?

0 Yes

4 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is stored in the mssqlsystemresource database? : sql server database administration

1081

what is denormalization? : Sql server database administration

975

Tell me what do we need queues in sql service broker?

1054

How can we improve performance by using SQL Server profiler?

1108

What is xml datatype?

1132

How will you hide an attribute? : sql server analysis services, ssas

1012

Explain different forms of normalization?

1004

What command is used to rename the database?

1089

Explain what is “asynchronous” communication in sql server service broker?

962

Explain difference between cross join and full outer join?

1068

Mention a few common trace flags used with sql server?

982

Can you change the data type of a column in a table after the table has been created? If so, which command would you use?

1085

Describe and explain about SQL native client?

1160

Difference between Inner vs outer joins?

988

What are trace flags and mention a few common trace flags used with sql server?

1144