How to select the duplicate rows from a table?
Answers were Sorted based on User's Feedback
Answer / channabasappa
select field name from tablename where group by field name
having count(field name)>1;
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / mahesh vasudevan
Select <col-name> from table A1 and A2
where A1.Col = A2.Col.
This should be an inner join. Then you are finding the
intersection of the key values...if you want to find the
duplicates for all matching column of the rows code AND
condition for join with all those columns.....by the way
there are different easy ways to find it. but this is one of
the way.
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / pandu
select distinct from <field name> from <table name>
Is This Answer Correct ? | 0 Yes | 3 No |
What is an instance database?
What is bind and rebind in db2?
What information can you find in SYSIBM.SYSLINKS table?
What are the prerogatives?
Can you search give an array in the WHERE clause of a db2 query?
Explain about rct.
can i code union in cobol-db2 pgm ?
What is with ur in db2?
What is a clustering index?
Explain packages.
how 2 resolve the -311 sqlcode
can any one give the list of some important sql abend codes which r frequently asked in interviews?