Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 8 Answers
- 16037 Views
- CGCI, I also Faced
- E-Mail Answers
Answer Posted / mail2sentha
DELETE FROM EMP WHERE ROWID NOT IN(SELECT MIN(ROWID)FROM
EMP GROUP BY EMPID);
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
How can you fetch common records from two tables?
what are the different tables present in mysql, which type of table is generated when we are creating a table in the following syntax: create table employee (eno int(2),ename varchar(10)) ? : Sql dba
Explain what is a subquery ?
What is multiple columns?
What is a clob in sql?
What are all ddl commands?
What is procedure in pl sql?
Is pl sql and postgresql same?
What is normalisation in sql?
Compare sql & pl/sql
What is pivot query?
How do I copy a table in sql?
describe transaction-safe table types in mysql : sql dba
What is a dirty read sql?
what are the authentication modes in sql server? How can it be changed? : Sql dba
