What are some SQL aggregates and other built-in functions?

Answer Posted / 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.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a system catalog table in db2?

590


Explain the function of data manager.

635


What is the use of predicate?

588


What is clone table?

592


What is declare cursor?

614






What does sqlcabc has?

633


How does cobol compile db2 program?

610


Can you tell me how can you find out the # of rows updated after an update statement?

612


What is a db2 package?

601


DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?

2285


Is db2 a mainframe database?

569


What is dbrm library?

580


What is buffer pool?

616


What is explain plan in db2?

592


If I have a view which is a join of two or more tables, can this view be updateable?

695