write a query to delete similar records in particular
fields(columns) in different tables
Answer Posted / khandu shinde
delete from emp where rowid not in ( select max(rowid) from
emp group by empno)
Is This Answer Correct ? | 7 Yes | 9 No |
Post New Answer View All Answers
Mention what does plv msg allows you to do?
How do I view a table in sql?
Why is a primary key important?
What jobs use sql?
Are null values same as that of zero or a blank space?
explain normalization concept? : Sql dba
what are all different types of collation sensitivity? : Sql dba
Is pl sql better than sql?
What are different types of functions in sql?
What is rownum?
What is the life of an sql statement?
What is the use of primary key?
Does view contain data?
Who developed sql?
What is sap sql?