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 the self-referencing constraint?

2 Answers  

what's the best lock size that you could use when you create a tablespace?

2 Answers   IBM,

can you use symbolic parameters in JOB?

5 Answers   IBM,

Can we use select * statement in cobol program without giving field names ???

3 Answers   Zensar,

WHAT IS NULL INDICATOR ? WERE IS THIS USED? AND IF IT IS USED IN FILES CONCEPT? HOW DO WE USE IT?

2 Answers   IBM,




Hi Team, Please tell me, If i don't declare the cursor in the program and i have given open and fetch and close, then what error will get.

6 Answers   IBM,

How to find schema of a table in db2?

0 Answers  

How does coalesce work?

0 Answers  

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  

How does DB2 use multiple table indexes?

1 Answers  

Which component is responsible for db2 startup and shutdown?

0 Answers  

This was related to -811 sqlcode, In a COBOL DB2 program which accesses employee table and selects rows for employee 'A', it should perform a paragraph s001-x if employee 'A' is present. In this case it gets -811 sqlcode, but still it process the paragraph s001-x. What could be wrong in my code.

3 Answers  

For more DB2 Interview Questions Click Here
Categories