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 different tables present in mysql? : Sql dba
Can a commit statement be executed as part of a trigger?
how to implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql dba
What are the basic sql commands?
What is normalization? How many normalization forms are there?
Explain what is a view?
Which are the different case manipulation functions in sql?
Can we call a function containing dml statements in a select query?
What is cascade in sql?
How do I install sql?
What is a field in a database?
how to convert character strings to dates? : Sql dba
What is nosql example?
Mention what does plv msg allows you to do?
How can check sql version from command line?