how to get duplicate records from tables?write qurey for this?
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 a buffer in memory?
How to rename a table in DB2 ?
How to fetch the last row from the table in SQL (db2)?
What is db2 stogroup?
What is the syntax for FETCH in DB2 ?
What is reorg and runstats in db2?
How do you stop a db2 database in linux?
How to find schema of a table in db2?
what is utility for parm lib
What is table space in db2?
What is a collection in db2?
What action db2 takes when a program aborts in the middle of a transaction?
What does db2 blu stand for?
What is alias in db2?
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.