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
- 5873 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 a credible reason why select* is never given preference in an sql program that has been embedded.
Can you tell me how can you find out the # of rows updated after an update statement?
Can SQL statements/queries be included in a copybook?
what is a plan and how do you refer the plan in the program?
Are views updatable ?
In terms of DB2 indexing, what is the root page?
What is dbrm library?
What is the information associated with sysibm.syslinks table?
What is host variable in db2 cobol?
WHAT IS MEANT BY COMMIT COMMAND?
select distinct(empid),distinct(dept),name from EMP will the above query work?
Name the various locking levels available?
COBOL 
