Answer / s

SQL aggregate functions
SUM,COUNT,MIN,MAX,AVG

BUILT-IN FUNCTIONS includes the above and other functions
like DATE,TIME,DAY,YEAR,DAYS,TIMESTAMP,NULLIF,HEX,SUBSTR

Answer / kishaloy bhowmick

Built in functions include all the mathematical functions
like sum,difference,multiply,division,max,min,avg.

And also date,time,year,month,timestamp etc.

What is blu acceleration in db2?

0 Answers  

---

How do I optimize a query in db2?

0 Answers  

---

What is the difference between Where and Having Clause

7 Answers   IBM, iFlex,

---

I have 1000 rows in a db2 table.I want to update first 100 records,How do I do it?

4 Answers   CTS,

---

wht steps we need will coding cobol and db2 pgm ?

6 Answers   CGI,

---

---

What's The Percentage Free Space ?

0 Answers   IBM,

---

I have some 3 particular fields ..i want to know which all tables have those 3 fields. Is there any way to identify.. can we know by quering system tables..

5 Answers   CTS,

---

What is declare cursor?

0 Answers  

---

Hi. I am currently working as a application developer. I would like to persue a DB2 certification exam. Can anybody please provide me the details about this exam like Syllabus, Cost and how to take the certification?

2 Answers  

---

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

2 Answers   IBM,

---

what's the error code for Unique Index Violation?

2 Answers  

---

db2 restart logic ?

1 Answers   DELL, HTC, UHG,

---