Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / channabasappa
select field name from tablename where group by field name
having count(field name)>1;
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Explain package in db2 and its advantages?
What is query_cache_limit?
What is rct?
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 the physical storage length of timestamp data type?
before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?
How can the duplicate values be eliminated from db2 select?
Discuss about db2 bind?
Why select is not preferred in embedded sql programs?
Is db2 a mainframe?
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?
Which component is responsible for processing sql statements and selecting access paths?
How is a typical db2 batch pgm executed?
How do I delete a table in db2?
What is netezza database?
