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
Answer Posted / kishor kumar
This can be solved by 2 Ways
One way
Create unique index on this Table with ignore duplicate row
2nd way.
1st transfer the data to a temp table bu using Distinct
clause then truncate the EMP table and then transfor the
data from temp table to EMP Table.
select distinct (column names) in to #temp from EMP
Truncate table EMP
INSERT INTO EMP
SELECT * FROM #temp
Is This Answer Correct ? | 9 Yes | 3 No |
Post New Answer View All Answers
Explain about Joins?
What are the types of ssrs?
Do you know how to implement service broker?
What are drilldown reports?
What is an identity column in insert statements?
Tell me what is difference between clustered and non clustered index?
What is the difference between varchar and nvarchar datatypes?
What do you mean by 'normalization'?
Benefits of Stored Procedures?
What is the advantage of sql server?
I have all the primary data files, secondary data files as well as logs. Now, tell me can I still restore the database without having a full backup? : sql server database administration
How to retrieve error messages using mssql_get_last_message()?
what is the difference between openrowset and openquery?
What is query optimizer in sql server?
What is ms sql server index?