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
- 5848 Views
- UST, I also Faced
- E-Mail Answers
Answer Posted / raja_kb
SELECT <Column Name1> FROM Table
GROUP BY <Column Name1> HAVING COUNT(*)>1;
| Is This Answer Correct ? | 7 Yes | 1 No |
Post New Answer View All Answers
What is bufferpool in db2?
What are the rules for db2 programming?
How connect db2 database to datastage?
What are host variables in db2?
Describe major components of db2?
Define check constraint.
How is the value function used?
How to get the ddl of a table in db2?
What is dbrm? When it will be created?
What is the role of schema in the db2 database?
What's The Error Code For Unique Index Voilation?
What os does db2 run on?
What is declare cursor?
How do you find the maximum value in a column in db2?
Which isolation level provides maximum concurrency?
