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 / 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 the main difference between sql and pl/sql?
what is blob? : Sql dba
What is the use of nvl function?
What is set serveroutput on?
Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me
what is auto increment? : Sql dba
What is the difference between rollback and rollback to statements?
what is the different between now() and current_date()? : Sql dba
Is sql dba a good career? : SQL DBA
How do sql databases work?
How do I make my sql query run faster?
what is a database transaction? : Sql dba
Explain correlated query work?
What is the difference between local and global temporary table?
how to extract a unit value from a date and time? : Sql dba