Delete duplicate records in the emp table.
Answer Posted / amedela chandra sekhar
delete from emp x where rowid>(select min(rowid) from emp
where rmpno=x.empno);
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How do you update a table in sql?
What schema means?
how can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba
How do you know if a relationship is 2nf?
What is the syntax to add a record to a table?
how to write date and time literals? : Sql dba
What is informix sql?
What are predefined functions in sql?
what are the non-standard sql commands supported by 'mysql'? : Sql dba
What are different categories of sql commands?
How many sql statements are used? Define them.
How to pronounce postgresql?
What are character functions?
Can we use two order by clause in query?
what are date and time data types in mysql? : Sql dba