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

Which component is responsible for db2 startup and shutdown?

In which column of which DB2 catalog would you find the length of the rows for all tables?

How do you define a correlated name?

Which DB2 catalog tables are used to produce a list of table column by table for all tables in a database?

What is meant by the attachment facility?

is there any restrictions for unions ?

How can you display the current date & current time ?

What is the size of a data page?

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

On which levels locks can be applied?

What is UNION,UNION ALL?

How to resolve the -305 error code in DB2? And also please let me know, how to resolve the db2 error codes.

For more DB2 Interview Questions Click Here