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 load replace in db2?

566


What is the syntax for creating a table in the db2 database?

638


How do you pull up a query which was previously saved in qmf?

684


Is ibm db2 free?

586


How is the value function used?

613






What are foreign keys in db2?

626


How do I add a column in db2?

604


Explain in detail about buffer manager and its functionalities?

576


How do I change the column size in db2?

611


What is difference between rollback and commit?

644


Explain the function done by data manager?

864


What is reorg and runstats in db2?

706


What is deadlock in db2?

589


What is db2? Explain.

613


What is the role of schema in the db2 database?

668