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
- 13945 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
Explain character-manipulation functions?
What are sql objects?
What is the command used to fetch the first 5 characters of a string?
what is the syntax used for partition in tsql? : Transact sql
What are stored procedures in mysql?
What are the types of triggers in sql?
Which join is default?
What is sql query optimization?
What is query execution plan in sql?
What is autocommit sql?
In what condition is it good to disable a trigger?
What is the difference between view and stored procedure?
What is error ora-12154: tns:could not resolve the connect identifier specified?
Why do we use view in sql?
What is the use of <> sql?
