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
- 14941 Views
- CGCI, I also Faced
- E-Mail Answers
Answer Posted / prajyot
Hi,
You can use the below mentioned query ....
SELECT ROWID( Emp_id ) FROM EMP WHERE Emp_id = 5;
Praj
| Is This Answer Correct ? | 1 Yes | 5 No |
Post New Answer View All Answers
Why is sql better than hql?
What is the best partition size for windows 10?
What if we write return in procedure?
What is the trigger in sql?
What is raw datatype in sql?
Write a sql query to get the third highest salary of an employee from employee_table?
What is trigger and stored procedure in sql?
what are the limitations of identity column? : Transact sql
What is blind sql injection?
Is primary key is clustered index?
What are primary key and foreign key and how they work?
How do I remove sql plus from windows 10?
How can you get sql*loader to commit only at the end of the load file? : aql loader
Which command is used to delete a trigger?
What are crud methods?
