how to delete duplicate rows from a specified table(only
single table)
how do you know which join is need to be used
Answer Posted / venkateswararao
delete from emp p where rowid<(select max(rowid) from emps where p.ename=s.ename)
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
what are the differences between get and post methods in form submitting. Give the case where we can use get and we can use post methods? : Sql dba
Can we write dml inside a function in sql server?
What can you do with pl sql?
How do I truncate a word?
How many aggregate functions are available there in sql?
What has stored procedures in sql?
what is text? : Sql dba
What is the use of pl/sql table?
How do I use google cloud in sql?
What is recursive join in sql?
Is sql difficult?
How many unique keys can a table have?
What is the use of index in hive?
What is the difference between sql and t sql?
What are actual parameters and formal parameters?