What are some SQL aggregates and other built-in functions?
- 2 Answers
- 4799 Views
- I also Faced
- E-Mail Answers
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
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?
What is the cobol picture clause of the db2 data types date, time, timestamp?
What is the clustering index in the db2 database?
What is db2 bind?
What is the maximum size of varchar data type in db2?
Which is faster delete or truncate?
what is a corelated subquerry?
How do we specify index to include or not during bind process.
What is a Foreign Key?
How does coalesce work?
What is difference between rollback and commit?
What is table space in db2?
What are iseries servers?
What is release/acquire in bind?
