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
- 16015 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
Write a unique difference between a function and a stored procedure.
What is not equal in sql?
how to use regular expression in pattern match conditions? : Sql dba
How does cross join work in sql?
Can we insert data into view?
What is the use of function in sql?
Can you select everything, but 1 or 2 fields, without writer's cramp?
what is unique key constraint? : Sql dba
How many sql statements are used? Define them.
Write a query to display the current date in sql?
What does t sql mean?
Is record in oracle pl sql?
Show how functions and procedures are called in a pl/sql block.
what is the difference between where clause and having clause? : Sql dba
Is progress software supports to ( pl/sql )?
