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
- 13 Answers
- 17335 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
what is bit datatype? : Sql server database administration
Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.
what is the sql equivaent of the dataset relation object ?
How to enable/disable indexes?
How to restore performance issues and how to check?
What happens if an integer is too big for int date type?
What do you mean by 'normalization'?
Name the different type of indexes in sql?
What are different replication agents and what's their purpose? : sql server replication
Write a program using SQL queries to find a unique entry in a table.
What are the differences between ms sql server & oracle?
What is the bookmark lookup and rid lookup?
Why I am getting "the microsoft .net framework 2.0 in not installed" message?
Can we join two tables without primary key?
What samples and sample databases are provided by microsoft?
