Interested to Buy Any Domain ? << Click Here >> for more details...
What are some SQL aggregates and other built-in functions?
- 2 Answers
- 5471 Views
- I also Faced
- E-Mail Answers
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
How can you quickly find out the # of rows updated after an update statement?
What is an instance in db2?
What is cobol db2?
What is the maximum length of sqlca?
What are the contents of a dclmgen?
i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?
What is the syntax for creating a table in the db2 database?
What is difference between rollback and commit?
What is the use of db2?
What is bind in db2?
What is syscat in db2?
If I have a view which is a join of two or more tables, can this view be updateable?
What is the usage of open cursor command?
What is the difference between nvl and coalesce?
Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?
