How to delete same emp id in sql query for exmaple in emp
table emp id, empname, emp address. for example emp id =5,
repeated in two times in rows same id how to delete same
empid please any one of the write query send in my id
Answer Posted / akshita
delete from emp where rowid not in (select max(rowid) from
emp group by empno)
| Is This Answer Correct ? | 11 Yes | 3 No |
Post New Answer View All Answers
what is an extent ? : Sql dba
How do I view output in sql developer?
tell me about various levels of constraint. : Sql dba
What are commit, rollback, and savepoint?
how to dump a table to a file with 'mysqldump'? : Sql dba
List the various privileges that a user can grant to another user?
What is the maximum size of sqlite database?
What does t sql mean?
How to change sql*plus system settings?
Explain how you can copy a file to file content and file to pl/sql table in advance pl/sql?
Which is faster joins or subqueries?
How do I edit a stored procedure?
What are sql functions? Describe the different types of sql functions?
In pl/sql, what is bulk binding, and when/how would it help performance?
How to display the current date in sql?