What are some SQL aggregates and other built-in functions?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
how do you resolve -805?
what is copy pending and check pending ?
What Utility is used to migrate DB2 from one release to the next?
What is an alias?
what is a collection?
How do I delete a table in db2?
how can you copy records present in a flat physical file to a database file(physical file).please explain in rpg400 with a simple example
What is a clustering index?
What is the difference between static and dynamic SQL?
What is a cursor and what is its function?
Hi. I am currently working as a application developer. I would like to persue a DB2 certification exam. Can anybody please provide me the details about this exam like Syllabus, Cost and how to take the certification?
Are views updatable ?