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 / vijay
Delete from emp where empid=5;
Is This Answer Correct ? | 4 Yes | 10 No |
Post New Answer View All Answers
Why is %isopen always false for an implicit cursor?
Explain the structure of pl/sql in brief.
Is left join faster than inner join?
Is clustered index a primary key?
What is query syntax?
Explain normalization and what are the advantages of it?
what is a foreign key ? : Sql dba
what are the differences between get and post methods in form submitting. Give the case where we can use get and we can use post methods? : Sql dba
What is sql integrity?
What is a sql*loader control file?
What is input buffer in sql*plus?
What is a constraint? Tell me about its various levels.
Under what condition it is possible to have a page level lock and row lock at the same time for a query? : Transact sql
Does user triggers have entry for trigger with compilation errors?
What is the usage of when clause in trigger?