select row_number()over() from table

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

Question Posted / ganesh

Answer Posted / ganesh

select row_number()over() from table_name

Is This Answer Correct ?

8 Yes

5 No

Please Help Members By Posting Answers For Below Questions

Which component is responsible for processing sql statements and selecting access paths?

1087

What are the bind parameters ibm db2?

1002

Is db2 relational database?

927

DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?

2798

What does runstats do in db2?

1037

How to create backup table in db2?

1055

What is buffer pool and list some of them?

992

Comment whether dclgen is mandatorily used. If not, then what is the point of using it?

1021

What are the uses of db2 optimizer?

1239

What are db2 objects?

1010

define clustering index.

986

How do you select a row using indexes in db2?

1081

How can we retrieve the total number of records in RPG & CLLE?

590

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

3534

Name the lockable units in DB2?

1083