Answer Posted / vamsi
for example our emp table have duplicate rows than we can
run this query to delete those duplicate rows
Delete from emp a
where rowid <> ( select max(rowid) from emp where empno =
a.empno);
| Is This Answer Correct ? | 13 Yes | 4 No |
Post New Answer View All Answers
Can triggers stop a dml statement from executing on a table?
What is pl sql package?
What are the sql versions?
What is the maximum number of columns in sql table?
What is the difference between the repeatable read and serializable isolation levels? : Transact sql
What is procedure explain with example?
what are the advantages of sql ? : Sql dba
What is sql trigger example?
What is data control language?
What is sql*loader and what is it used for?
Can we create a trigger on view?
What is the difference between a procedure and a function?
What is a mutating table and a constraining table?
What are the various restrictions imposed on view in terms of dml?
Is natural join and inner join same?
