Interested to Buy Any Domain ? << Click Here >> for more details...
write a query to delete similar records in same table
- 13 Answers
- 24555 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
what is the difference between blob and text? : Sql dba
GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?
What is trigger with example?
How does postgresql compare to mysql?
what is cross join? : Sql dba
i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5
Which sql statement is used to return only different values?
what are the limitations of mysql in comparison of oracle? Mysql vs. Oracle. : Sql dba
Can we use views in stored procedure?
how to load data files into tables with 'mysqlimport'? : Sql dba
Show the cursor attributes of pl/sql.
what is a table called, if it has neither cluster nor non-cluster index? What is it used for? : Sql dba
How many types of primary keys are there?
How can a function retun more than one value in oracle with proper example?
How do you break a loop in pl sql?
