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
- 14942 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 sql database should I use?
How do I truncate a word?
Why we use cross join?
Can we create a trigger on view?
Does view contain data?
What are different types of statements supported by sql?
What is the difference between an inner join and an outer join?
what is the difference between blob and text? : Sql dba
How to use transactions efficiently : transact sql
How delete all data from table in sql?
What is group function in sql?
how can we transpose a table using sql (changing rows to column or vice-versa) ? : Sql dba
what is log shipping? : Sql dba
Can we create index on primary key?
What are sql ddl commands?
