how to get duplicate records from tables?write qurey for this?
- 4 Answers
- 8815 Views
- ANZ, I also Faced
- E-Mail Answers
Answer Posted / anshuman
Select column_name1,column_name2
from table_T
group by column_name1 having count(*)>1
it will give all the duplicates value of column_name1
| Is This Answer Correct ? | 28 Yes | 7 No |
Post New Answer View All Answers
How to find the maximum value in a column in the db2 database?
What is release/acquire in bind?
How can you count the number of rows from a table tab?
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
Differentiate between cs and rr isolation levels? Where do you specify them?
Which component is used to execute the sql statements?
Are views updateable?
What is check constraint in db2?
Is it possible using max on a char column?
How to get the ddl of a table in db2?
What is db2 stogroup?
What is the physical storage length of the data types: date, time, timestamp in the db2 database?
How to create backup table in db2?
What is the physical storage length of date data type?
What does a deadlock mean in DB2?
