use distinct keywor in sql query

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 / samadhan

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

Answer Posted / samadhan

use distinct keywor in sql query

Is This Answer Correct ?

1 Yes

4 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Can sql servers link to other servers?

1028

What are the properties and different types of sub-queries?

963

What is change tracking in sql server?

946

Give me any three differences between Truncate and Delete.

1047

How self join is different from outer join?

1066

What is in place upgrade in sql server?

991

what is a live lock? : Sql server database administration

893

what are the reporting service components in SSRS?

153

Is there any difference between the primary key and unique key?

957

What is implicit mode in sql server?

1035

What is a View ? Can we insert, Update and delete a view?

942

What is the difference between inner join and equi join?

929

Describe in brief sql server monitoring ways.

1006

What is scheduled job and how to create it?

926

How would you use user_constraints table in DB?

943