Sign Up Login


  1. Categories >> Software >> MainFrame >> IBM MainFrame >> DB2
  2. Suggest New Category

Q4. How will you get the count of record without using COUNT verb in query?

Question Posted / vaibhavaguta

Answers were Sorted based on User's Feedback



Q4. How will you get the count of record without using COUNT verb in query?..

Answer / ganesh

select row_number()over() from table_name

Is This Answer Correct ?    8 Yes 5 No

Q4. How will you get the count of record without using COUNT verb in query?..

Answer / sasidharreddy

by using inspect

Is This Answer Correct ?    6 Yes 3 No

Post New Answer

More DB2 Interview Questions

What is buffrpool? Where we use it ?

2 Answers   Tesco,

how do you resolve -805?

3 Answers   HCL,

What is buffer pool?

0 Answers  

What do you need to do before you do EXPLAIN ?

1 Answers  

What is a recovery log?

1 Answers  

What are PACKAGES ?

3 Answers  

How to take backup of table in db2?

0 Answers  

what is a trigger and types of triggers

3 Answers   HSBC,

List down the data types in the db2 database.

0 Answers  

What do you mean by between and in? Is between inclusive of specified range values?

0 Answers  

How to resolve -818 sql code in DB2?

2 Answers   Cap Gemini,

I have two tables A and B. Both tables are connected with SSN number as foreign key. I want to retrieve a column data from B table. How will you write a query?

3 Answers   CTS,

For more DB2 Interview Questions Click Here
Categories