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 |
Name some fields from SQLCA.
What is a buffer in memory?
How will you return the number of records in table?
What are the various locking levels available?
What is null indicator in cobol db2?
why db2 is called as universal database?what is the storage capacity of db2v9 n what are the advantages of db2
How do I optimize a query in db2?
Which catalog table stores referential constraints?
What is schema in db2?
How does one bind 2 versions of a CICS transaction with the same module name in two different CICS regions that share the same DB2 subsystem?
Explain about mirror activator disk mirroring?
can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well