Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 16310 Views
- CGCI, I also Faced
- E-Mail Answers
Answer Posted / mail2sentha
DELETE FROM EMP WHERE ROWID NOT IN(SELECT MIN(ROWID)FROM
EMP GROUP BY EMPID);
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
What are the limitations of sql express?
what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql
Can ddl statements be used in pl/sql?
What is offset in sql query?
Can we insert data into view?
how to shutdown mysql server? : Sql dba
Is sql microsoft?
Why function is used in sql?
Why partition by is used in sql?
What does the base_object_type column shows in the user.triggers data dictionary view?
How to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?
Why is partition used in sql?
How do you break a loop in pl sql?
List the various privileges that a user can grant to another user?
How long does it take to learn pl sql?
