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
- 16331 Views
- CGCI, I also Faced
- E-Mail Answers
Answer Posted / akshita
delete from emp where rowid not in (select max(rowid) from
emp group by empno)
| Is This Answer Correct ? | 11 Yes | 3 No |
Post New Answer View All Answers
What is the difference between having clause and where clause?
What is a record in a database?
What is the difference between numeric and autonumber?
What is out parameter used for eventhough return statement can also be used in pl/sql?
Can one improve the performance of sql*loader? : aql loader
What are analytical functions in sql?
Is left join inner or outer?
What is crud diagram?
What is the difference between Union and Union all. Which is faster.
What is sql server and ase?
Define overloaded procedure?
Why should I use postgresql?
how to shut down the server with 'mysqladmin'? : Sql dba
What are aggregate functions in sql?
what is table? : Sql dba
