What are some SQL aggregates and other built-in functions?
Answer Posted / 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
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What do you mean by commit and rollback?
What is runstats utility in db2?
What does sqlcabc has?
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
My sql statement select avg(salary) from emp yields inaccurate results. Why?
Outputs of explain are with matchcols = 0. What does this signify?
What is ibm db2 used for?
What is catalog database in db2?
Can you tell me how can you find out the # of rows updated after an update statement?
What do you mean by between and in? Is between inclusive of specified range values?
Is it possible to create an Instance in DB2 using DB2 Control Center ?
What does db2 blu stand for?
What is declare cursor?
What is dbrm?
What is the information associated with sysibm.syslinks table?