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 purpose of rollback and commit?

0 Answers  

how do you resolve -805?

3 Answers   HCL,

How can the duplicate values be eliminated from db2 select?

0 Answers  

My sql statement select avg(salary) from emp yields inaccurate results. Why?

0 Answers  

What are the rules for db2 programming?

0 Answers  

Following a db2 update statement, what is the quickest way to compute the total number of updated rows?

0 Answers  

What is the difference between a package and a plan?

6 Answers   Infosys, L&T, Mphasis,

How to find primary key of a table in db2?

0 Answers  

What is image copy?

1 Answers   Virtusa,

What is nvl in db2?

0 Answers  

wt is view ? wht r the restrictions for view ?

3 Answers   Verizon,

How to execute stored procedure in db2 command editor?

0 Answers  

For more DB2 Interview Questions Click Here
Categories