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

Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?

3157

List down the types of triggers in the db2 database?

1033

List some fields from sqlca?

1060

What is the difference between cursor and select statement?

1107

What is a collection in db2?

1036

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

1129

How to run db2 command in windows?

1193

What is explain plan in db2?

999

What are db2 objects?

1049

What do you mean by cursor?

988

what is a corelated subquerry?

1122

Mention a credible reason why select* is never given preference in an sql program that has been embedded.

1197

What is the use of value function?

1151

What is db2 look?

1026

What is a system catalog table in db2?

1187