How will you return the number of records in table?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More DB2 Interview Questions

I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?

3 Answers  


Is db2 a mainframe database?

0 Answers  


is it compulsory commitment control in journal?

0 Answers   TCS,


What is SPUFI?

4 Answers  


i want to know how the commit option works,how it save the changes? it will update the database or what ? where we can see these saved changes?

4 Answers  






what is difference between Plan and Package

1 Answers   Syntel,


What does runstats do in db2?

0 Answers  


What is the picture clause of null indicator variable?

0 Answers  


What is a composite index and how does it differ from a multiple index?

1 Answers  


What types of tables are there in the db2 database?

0 Answers  


Can we declare cursor in Procudere division or open the cursor in the Working storage section. Is there any particular rules in the usage of cursors lifecycle

1 Answers   Infosys,


Suppose there are many duplicate records in a Db2 table. What is the query to retrive only duplicate records?

4 Answers  


Categories