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

What is a heap?

1032

optimization techinques

2674

How to create a view using data from another view?

948

how you can get the list of largest tables in a database? : Sql server administration

1053

What are the properties of the relational tables?

879

How to retrieve error messages using mssql_get_last_message()?

1052

What does asynchronous call backs means?

1155

What is database replication?

1140

Explain indexed views and partitioned view with their syntax.

1146

Explain what is lock escalation and what is its purpose?

927

What is the difference between stored procedure and functions?

1133

What is sql server used for?

1048

What are different types of statement?

1017

Explain important index characteristics?

1031

What is the difference between ddl and dml?

1047