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
How many types of privileges are available in sql?
What is an alias command?
What is a temporal table?
Is it possible to sort a column using a column alias?
what are the differences between binary and varbinary? : Sql dba
What is tuple in sql?
How can we make an if statement within a select statement?
How do I view an execution plan in sql?
How many clustered indexes can be created on a table?
Can you skip header records while loading? : aql loader
Explain the difference in execution of triggers and stored procedures?
What is faster join or subquery?
What are the different types of tables in sql?
What is the difference between left outer join and left join?
How many columns should be in an index?