Interested to Buy Any Domain ? << Click Here >> for more details...
how to get duplicate records from tables?write qurey for this?
- 4 Answers
- 9884 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
Mention some fields that are a part of sqlca.
Is it possible using max on a char column?
Define db2.
What is buffer pool?
Define sqlca.
What kind of database is db2?
What is commit in db2?
What is the purpose of rollback and commit?
Why do we bind in db2?
Can we delete records from view?
What is db2 purescale?
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.
what is db2 restart?
What do you mean by storage group (stogroup)?
What are iseries servers?
