AGGREGATE function support by DB2.
A) SUM & AVG
B) SUM, MIN & AVG
C) SUM, MAX, AVG , MIN &COUNT
D) NONE
Answers were Sorted based on User's Feedback
How can the firstname and the lastname from the emp table be concatenated to generate complete names?
what is the soft code for deadlock ?
What are the disadvantages of PAGE level lock?
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
Why do we need to create an alias if we can directly use the table name? What are the benefits of referring a table name by its alias? Also, when should we go for alias and when for synonyms?
Explain the contention situations caused by locks?
How to rename a table in DB2 ?
Is it possible using max on a char column?
What is query_cache_limit?
Why do we bind in db2?
Who uses db2?
Mention the length of physical storage of the given data types of db2 – date, timestamp, time