Write an SQL Query to
Delete Duplicate records from a table using ROWID.
Answers were Sorted based on User's Feedback
Answer / koti
Ganesh ,You are right very good.
delete from emp t
where rowid != ( select min(rowid)
from empno
where empno = t.empno );
---------And other answers are not right .
Is This Answer Correct ? | 15 Yes | 16 No |
Answer / madhuapps
delete from t1 tl
where tl.rowid >
( select min(tl2.rowID) from t1 tl2
where tl.col1 = tl2.col1
and tl.col2 = tl2.col2)
Is This Answer Correct ? | 25 Yes | 31 No |
Answer / satyan
simple query
step 1
select rowid,column1,column2,column3 from table name where
condition;
step 2
delete from table name where rowid = '........'
Is This Answer Correct ? | 4 Yes | 11 No |
Answer / ganesh
delete from emp t
where rowid != ( select min(rowid)
from empno
where empno = t.empno );
Is This Answer Correct ? | 14 Yes | 24 No |
what do u mean by debit/credit memo invoices?
3 Answers ACC, Convergys, Mascon,
how will u do documentation
why r u transer the data base tables to flat file and what is use
how can i print random rows in plsql table
How will U link GL with OU in Multi-org environment.
After execution of a report we get parameter layout where we have enter From_date and To_date.After entering From_date and without entering To_date what happen a report will execute or not?
In xml report, how to print the headings in every page?
any one can expalin report registration steps?
what is meant by bind parameter?
tell me the scenarios of the independent in reports
How we will receive the work from the client? what type of documents we will develop in the entire implementation project? plz tell me the total scinario?
2 Answers Deloitte, Intelligroup,
what are the different transaction clauses in AR?