Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 5794 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 |
How to see the structure of db2 table??
How can you compare table column after update and before update?
How do I delete a table in db2?
wht is d/f between union and joins ?
What's the difference between DB2 active log and archive log? Thanks a lot...
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
Is ibm db2 free?
Once you create a view, where would information about the view be stored?
Which catalog tables contain authorization information?
How does DB2 store NULL physically?
What does runstats do in db2?
What is image copy in db2?
COBOL 
