What are the functions in DB2?

Question Posted / subbu

3 Answers
9518 Views
Satyam, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

What are the functions in DB2?..

Answer / mainframe virumbi

the following functions ( Aggregate functions )applied on
the columns.

Count
Avg
Min
MAx
....

Is This Answer Correct ?

13 Yes

0 No

What are the functions in DB2?..

Answer / rob

what about sum

Is This Answer Correct ?

6 Yes

0 No

What are the functions in DB2?..

Answer / bhaskar reddy

the aggrigate function are
min, max, avg, sum, count

Is This Answer Correct ?

1 Yes

0 No

Post New Answer

More DB2 Interview Questions

What is null value in db2?

0 Answers

What is the purpose of using commit?

0 Answers

What r the comman abends in db2, jcl and cobol???????

0 Answers Mphasis,

if suppose i am having an ACCOUNT table with 3 coloumns ACC. NO,ACC. NAME,ACC. AMOUNT . If a unique index is also defined on ACC.NO and ACC.NAME then write a query to retrieve account holders records who have more than 1 ACC.

8 Answers Wipro,

i have a db2 variable how do u declare tht into working storage section ?

1 Answers TCS,

Is the primary key a clustered index?

0 Answers

What is copy book?

1 Answers Thomson Reuters,

What is a Foreign Key?

0 Answers Tavant Technologies, Zensar,

what is a plan and how do you refer the plan in the program?

2 Answers Xansa,

List some fields from sqlca?

0 Answers

What is the difference between dbm cfg and db cfg file in db2 ?

0 Answers MCN Solutions,

What information is held in SYSIBM.SYSCOPY?

1 Answers

For more DB2 Interview Questions Click Here