Interested to Buy Any Domain ? << Click Here >> for more details...
How to retrieve duplicate rows in a table?
How to delete the duplicate entries in a table?
- 15 Answers
- 32622 Views
- Leo Technologies, Mannar Company, Synechron, I also Faced
- E-Mail Answers
Answer Posted / gaurav jain
begin
select distinct * into #one from four where id in (select
id from four group by id
having count(*)>1)
delete from four where id in (select id from four group by
id having count(*)>1)
insert into four select * from #one
end
| Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
How much is a sql server license?
Explain steps of normalization?
Why is the need for data conversion transformations?
What are two difference between sql azure and azure tables?
Why it is recommended to avoid referencing a floating point column in the where clause?
List the data types available in mssql?
Explain the use of keyword with encryption. Create a store procedure with encryption?
Can we update data in a view?
What is the use of toad or sqldbx.?
Do you know what is user defined datatypes and when you should go for them?
How to connect a database with sql express.?
What is Extended user-defined?
How dts is used to extract, transform and consolidate data?
What are the underflow and overflow behaviors on float literals?
Explain sql server authentication modes?
