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


Please Help Members By Posting Answers For Below Questions

Why is %isopen always false for an implicit cursor?

566


Explain the structure of pl/sql in brief.

616


Is left join faster than inner join?

611


Is clustered index a primary key?

525


What is query syntax?

517






Explain normalization and what are the advantages of it?

514


what is a foreign key ? : Sql dba

603


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

668


What is sql integrity?

577


What is a sql*loader control file?

613


What is input buffer in sql*plus?

637


What is a constraint? Tell me about its various levels.

634


Under what condition it is possible to have a page level lock and row lock at the same time for a query? : Transact sql

527


Does user triggers have entry for trigger with compilation errors?

590


What is the usage of when clause in trigger?

563