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

Explain linked server in sql?

1296

What are the differences in Clustering in SQL Server 2005 and 2008 or 2008 R2?

1104

How to call a function from a stored procedure in SQL Server ?

1088

What is partition index in sql server?

1176

What is difference between cte and view?

979

explain extended properties

1039

Can you move the resources after pausing the node? : sql server database administration

1171

What is difference between equi join and natural join?

1126

What is oltp (online transaction processing)?

1061

what is datawarehouse?

1159

what is the main function of a query parameter?

155

What is extended stored procedures?

1030

Do you know hot add cpu in sql server 2008?

1004

What is the default Port No on which SQL Server listens?

1183

What is lookup override?

1083