select row_number()over() from table

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

Question Posted / ganesh

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

Answer Posted / ganesh

select row_number()over() from table_name

Is This Answer Correct ?

8 Yes

5 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well

2175

define clustering index.

976

What is null indicator in db2?

1049

What is reorg?

1069

What parameters are used to control the free space in DB2?

1006

How to execute stored procedure in db2 command editor?

983

Mention the way of highlighting as well as putting a cursor to use in a cobol program.

1017

How do you pull up a query which was previously saved in qmf?

1098

What is bind plan?

975

How to retrieve rows from a db2 table in embedded sql?

1323

What is a page in db2?

979

What is a bind card?

1140

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

1081

What is buffer pool?

1028

How do I import a csv file into db2?

936