Interested to Buy Any Domain ? << Click Here >> for more details...
write a query to delete similar records in same table
- 13 Answers
- 25139 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / swapna
One way is to rename the original table to something else,
and copy the unique records into the original table.
rename 'Table2', 'Table1'
select distinct * into Table2 from Table1
drop table1
| Is This Answer Correct ? | 5 Yes | 13 No |
Post New Answer View All Answers
Can you select everything, but 1 or 2 fields, without writer's cramp?
Explain what is a database?
How would you reference column values before and after you have inserted and deleted triggers?
What is the trigger in sql?
What is the difference between jpql and sql?
What are the types pl/sql code blocks?
How many postgresql users are there, worldwide?
Is sql a dbms?
what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba
What is raw datatype in sql?
How is a process of pl/sql compiled?
What is int identity in sql?
Explain aggregate functions are available there in sql?
What are joins in sql?
how to do backup entire database? : Transact sql
