Answer Posted / nans
Select FIELD1 From <TABLENAME> As Temp Group By FIELD1 Having
Count(*) >1;
| Is This Answer Correct ? | 14 Yes | 1 No |
Post New Answer View All Answers
What are catalog tables in db2?
Explain correlated sub-queries.
What kind of database is 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.
Is it possible to create an Instance in DB2 using DB2 Control Center ?
How do I add a column to a table in db2?
Explain about dbrm.
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?
Highlight all the advantages that are attached to a package.
What is a page in db2?
How will you return the number of records in table?
How can you classify the locks in db2?
What is the use of runstats in db2?
What is data manager?
Explain the function of data manager.
