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
- 16002 Views
- CGCI, I also Faced
- E-Mail Answers
Answer Posted / rohit kumar
Delete from employee where (empid,empname) notin (select min
(empid),empname from employee group by enmpname);
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What trigger means?
What are the types pl/sql code blocks?
Why truncate is faster than delete?
What are the different types of constraints?
what is the difference between where clause and having clause? : Sql dba
how to rename an existing column in a table? : Sql dba
What makes a good primary key?
Which are the different character-manipulation functions in sql?
What is dense_rank?
how to dump a table to a file with 'mysqldump'? : Sql dba
How do I truncate a word?
Explain what is a database?
Are stored procedures compiled?
can sql servers linked to other servers like oracle? : Sql dba
how to shut down the server with 'mysqladmin'? : Sql dba
