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
- 15993 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 materialized view in sql?
What is the difference between local variables and global variables?
What are the advantages of sql? Explain
1. is it possible to use the cursor atttibutes (%found ,% rowcount , %isopen , %notfound ) to our user defined cursor names ....... cursor cursor_name is select * from scott.emp if you use... cursor_name%found , %rowcount ,%isopen,%notfound...will it work... -------------------------- 2.what is the difference between the varray and index by table .. -------- 3. type type_name is table of number(8,3) index by binary_integer; identifier_name type_name; first , last , prior , next ,trim are the methods we can use it for the above type...simillary is there any way to apply for cursors... with thanks and regards..sarao...
What is a sql schema used for?
What are the advantages of indexing?
Can we create table inside stored procedure?
What is user defined functions?
Why self join is used in sql?
Table A Table B 1 1 2 1 3 1. Union & union all --> A Union B , A Union all B 2. Minus , Intersect --> A minus B , B Minus A , A Intersect B 3. Joins A join B , A Left Join B A Right Join B , A full Join B 4. %Type - Uses & Benifit 5. Truncate & Delete 6. Pragma Autonomus Transaction 7. how to Perform DDL from function or procedure 8. Can we have DML inside Function 9. Rank & Dense Rank diffrence 10. Water Mark in Oracle 11. Index , Can we have index in all column of table if no then why ?
How do I find duplicates in sql?
what is a trigger? : Sql dba
What is the difference between cluster and non-cluster index?
Explain the significance of the & and && operators in pl sql.
What is primary key and foreign key?
