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

More DB2 Interview Questions

What are the three DB2 date and time data types and their associated functions?

When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?

Why might full image copies be faster to implement than an incremental image copy?

What are db2 tables?

how many bytes timestamp token occupies?

Which components manage deadlocks in db2?

what is load and unload in db2

What are the 4 environments which can access DB2 ?

How can you display the current date & current time ?

is it compulsory commitment control in journal?

What if we try to insert the base table through updatable view , but failed to give a column value which is defined as NOT NULL.

When will you chose to run RUNSTATS?

For more DB2 Interview Questions Click Here