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
How to run db2 command in windows?
What type of database is db2?
What do you mean by between and in? Is between inclusive of specified range values?
What is runstats and reorg in db2?
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
What is the syntax for seeing the columns and data types of a table in the db2 database?
How can you quickly find out the # of rows updated after an update statement?
What is a db2 collection?
What is the difference between spufi and qmf?
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?
What is cursor stability in db2?
What is the difference between dbm cfg and db cfg file in db2 ?
What do you mean by storage group (stogroup)?
Explain in detail about buffer manager and its functionalities?
What is lock escalation in db2?