how to delete duplicate rows from a specified table(only
single table)
how do you know which join is need to be used
Answer Posted / venkateswararao
delete from emp p where rowid<(select max(rowid) from emps where p.ename=s.ename)
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is gpt format?
what is the use of set statement in tsql? : Transact sql
Explain what is a subquery ?
in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.
What is break?
what is the functionality of the function htmlentities? : Sql dba
What is meant by <> in sql?
How can triggers be used for the table auditing?
What is assignment operator in pl sql?
what is try_catch block in procedure
What are procedures used for?
How delete all data from table in sql?
what does the t-sql command ident_incr does? : Transact sql
What is count * in sql?
How can a function retun more than one value in oracle with proper example?