Interested to Buy Any Domain ? << Click Here >> for more details...
how to get duplicate records from tables?write qurey for this?
- 4 Answers
- 10117 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
What is package in db2 mainframe?
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
What is access path in db2?
What is the use of dclgen in db2?
What is catalog database in db2?
How do I start db2 in windows?
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
What is data manager?
Explain in detail about buffer manager and its functionalities?
Is db2 a programming language?
How do I delete a table in db2?
What are the different types of base tables?
What is a db2 schema?
What is syscat in db2?
What os does db2 run on?
