how will i display the duplicate record's from a table...
i don't want to eliminate ...i want to display the duplicate
record...for example in my table i have 10 record's like
record no(1,2,3,4,2,9,6,1) in this ...so i want to receive
duplicates...
Answer / raja_kb
SELECT <Column Name1> FROM Table
GROUP BY <Column Name1> HAVING COUNT(*)>1;
| Is This Answer Correct ? | 7 Yes | 1 No |
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
Mention the various locks that are available in db2.
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
Can there be more than one cursor open for any program?
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?
What is the physical storage length of time data type?
What is the picture clause of the null indicator variable?
Plan is an executable form of sql statements,But what exactly resides inside a Plan. what are the details inside Plan.
What is DCLGEN ?
What do you need to do before you do EXPLAIN ?
What is the syntax required for the creation of a cursor?
database DSNDB01 means a.db2 catalog b.db2 directory c.BSDS d.active logs answer with reason please