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 role of the data page in the db2 database?

0 Answers  

What is the difference between SYNONYM and ALIAS?

6 Answers   TCS,

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

2 Answers   IBM,

Mention data types used in db2 ?

0 Answers  

How to resolve -504 sql code in DB2?

2 Answers   Cap Gemini,




What do you need to do before you do EXPLAIN?

1 Answers  

Why PS file called Physical seqential file?How to sore data in sequential file and ESDS file? What is the use of DBRM,PLAN,package and Collection.

1 Answers  

What is cursor stability in db2?

0 Answers  

Is ibm db2 open source?

0 Answers  

What is phantom read in db2?

0 Answers  

Can you search give an array in the WHERE clause of a db2 query?

1 Answers  

what is cursor stability?

2 Answers   IBM,

For more DB2 Interview Questions Click Here
Categories