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
- 14934 Views
- CGCI, I also Faced
- E-Mail Answers
Answer Posted / ajit
DELETE FROM EMP WHERE EMPID= 5 AND ROWNUM < 2;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is inner join in sql?
What is nvarchar in sql?
What are the advantages of indexing?
Does access use sql?
What is sql performance tuning?
What is the difference between subquery and correlated query?
what is innodb? : Sql dba
What is a file delimiter?
Name the operator which is used in the query for pattern matching?
can a stored procedure call itself or recursive stored procedure? : Sql dba
What are different types of queries in sql?
Define concurrency control. : Transact sql
What is flag in sql?
Is crud a cuss word?
how to shutdown mysql server? : Sql dba
