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
What is a system catalog table in db2?
Explain the function of data manager.
What is the use of predicate?
What is clone table?
What is declare cursor?
What does sqlcabc has?
How does cobol compile db2 program?
Can you tell me how can you find out the # of rows updated after an update statement?
What is a db2 package?
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
Is db2 a mainframe database?
What is dbrm library?
What is buffer pool?
What is explain plan in db2?
If I have a view which is a join of two or more tables, can this view be updateable?