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
Which command is used to connect to a database in DB2 ? Give the Syntax.
Define check constraint.
what is a corelated subquerry?
What is buffer pool?
What is bufferpool in db2?
How many types of page locks can be held in db2?
What is runstats db2?
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
Is ibm db2 open source?
What is db2? Explain.
What is isolation level in db2?
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
Which isolation level provides maximum concurrency?
What are catalog tables in db2?