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.

wht is d/f b/w inner join and outer join ? d/f group by and order by having by ?

2 Answers  

---

Is it possible to create an Instance in DB2 using DB2 Control Center ?

0 Answers   MCN Solutions,

---

what is the difference between normal select query and currosor

2 Answers   Cap Gemini, TCS,

---

What do you mean by storage group (stogroup)?

0 Answers  

---

Explain in detail about buffer manager and its functionalities?

0 Answers  

---

---

what is check point and restart Logic ? why do we go for that ??

2 Answers   CGI, UST, Xansa,

---

How to insert more than one record using insert?

7 Answers   Atos Origin, IBM,

---

wht displays the number of times a query modified ?

2 Answers   TCS,

---

I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?

3 Answers  

---

How to find primary key of a table in db2?

0 Answers  

---

Why select is not preferred in embedded sql programs?

0 Answers  

---

how can u understand the end of the table ?

1 Answers   TCS,

---