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
- 5771 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 |
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
What is load utility in db2?
How do we specify index to include or not during bind process.
What is bind and rebind in db2?
can any one expalin check point with an example?
What are db2 objects?
What does DML stand for and what are some examples of it?
i hav created a program and moved to production but failed to create the table which is been used in the program. the program shows error as soon as it is moved or installed in production or shows error during its runtime. what is the sqlcode for this error
How can we retrieve the total number of records in RPG & CLLE?
What is package versioning? Please give an example.
insert into tablename a column1, column2 select column1, column2 from tablename b i am getting abend -104..can any one help?
How are write I/Os from the buffer pool executed?
COBOL 
