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

Question Posted / vaibhavaguta

2 Answers
11700 Views
IBM, I also Faced
E-Mail Answers

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 db2 look?

0 Answers

I have some 3 particular fields ..i want to know which all tables have those 3 fields. Is there any way to identify.. can we know by quering system tables..

5 Answers CTS,

what is utility for parm lib

0 Answers IBM,

the dd name for ksds is dest1 and what is the dd name for alternate index of ksds ? a.dest b.dest1 c.dest1a d.dd1

2 Answers Logica CMG,

how to resolve -818 error. how to see timestamp token in load module and plan

4 Answers IBM,

db2 restart logic ?

1 Answers DELL, HTC, UHG,

What is PRIME TABLE and what are the uses of it

1 Answers

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,

For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.

0 Answers

If I have a view which is a join of two or more tables, can this view be updatable?

3 Answers

How to create db2 table in mainframe?

0 Answers

What is Reorg Recovery? when will you run it?

2 Answers

For more DB2 Interview Questions Click Here