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...
- 1 Answers
- 5155 Views
- UST, I also Faced
- E-Mail Answers
Answer / raja_kb
SELECT <Column Name1> FROM Table
GROUP BY <Column Name1> HAVING COUNT(*)>1;
| Is This Answer Correct ? | 7 Yes | 1 No |
What is the self-referencing constraint?
How to know the primary key of a table without defining the primary key in the table?
What are iseries servers?
What is an instance database?
What happens to a tablespace when its recovery infromation has been removed and a full recovery is no longer possible?
What can the SET option of the Repair Utility accomplish?
What is ALTER ?
Explain packages.
Can you access the DB2 Directory table using SQL?
what is differnece between DROP TABLE & DELETE TABLE .
What is the function of buffer manager?
what is check point and restart Logic ? why do we go for that ??
COBOL 
