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

Difference between report and query parameter. Why do we need different type of parameter?

960

What does COMMIT command do?

1067

Recommend an approach to ensuring that all changes in the remote databases synchronize with the SQL Azure database?

128

What are cursors and when they are useful?

1089

What is an index in sql?

1006

What program is used to store the data source file?

962

What are the various editions of sql server 2017 that are available in the market?

892

What is the use of attributehierarchyvisible ? : sql server analysis services, ssas

1066

Where is localdb stored?

943

What is single-user mode?

941

What is explicit cursors?

1074

Explain time data type in sal server 2008?

924

Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?

1327

What are the options which must be set to allow the usage of optimistic models?

963

What is a fan-out query in SQL Azure?

121