1. Categories >> Software >> MainFrame >> IBM MainFrame >> DB2
  2. Suggest New Category

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

Post New Answer

More DB2 Interview Questions

What is FREEPAGE and PCTFREE in TABLESPACE creation?

1 Answers  

i know the stpes 2 create an executable CICS/DB2 cobol code. 1. DB2 Precompiler converts the SQL Statements into COBOL API statements and creates another member with Acess plans. CodeA results in CodeB (code with API calls) & CodeC ( Access Plans ) 2.Code B is compiled/linked 2 create an exceutable.(codeE) 3.Now CodeC is binded to the database on which CodeE will be run. Can somebody provide me the sample JCLs for precompile/compile/link/bind.

0 Answers  

what is copy pending and check pending ?

1 Answers   Xansa,

What is meant by dclgen?

0 Answers  

What is load replace in db2?

0 Answers  




Can All Users Have The Privilege To Use The SQL Statement Select (DML)?

1 Answers  

Suppose there are many duplicate records in a Db2 table. What is the query to retrive only duplicate records?

4 Answers  

What is meant by index cardinality?

2 Answers  

What is a DBRM, PLAN ?

3 Answers  

before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?

0 Answers   IBM,

What are the abend codes occour in ur latest PROJECT in DB2

2 Answers   Cap Gemini,

What is a page?

2 Answers  

For more DB2 Interview Questions Click Here
Categories