Delete duplicate records in the emp table.
Answer Posted / srinivas ganamur
Delete from table t1
where t1.rowid>(select from table t2
from table t2
where t1.col_name=t2.col_name);
Srinivas Ganamur
Bangalore
Is This Answer Correct ? | 7 Yes | 3 No |
Post New Answer View All Answers
How do I count records in sql?
Does google use sql?
What are the different operators available in sql?
explain the options of myisamchk to improve the performance of a table. : 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
What are the commands used in sql?
What is the maximum size of sqlite database?
How to add, remove, modify users using sql?
What are different sql data types?
What is dialect in sql?
Is join an inner join?
Can we enter data in a table in design view?
Can you select everything, but 1 or 2 fields, without writer's cramp?
Show how functions and procedures are called in a pl/sql block.
what are the different functions in sorting an array? : Sql dba