Interested to Buy Any Domain ? << Click Here >> for more details...
What are some SQL aggregates and other built-in functions?
- 2 Answers
- 5392 Views
- I also Faced
- E-Mail Answers
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 |
what is Runstats? Whem will u choose to runatats?
Do we have any optinon to search part of integer in DB2 as we have for character Like,SUBSTR optins?
Hi , I am posting some interview ques . what is the use of cursors ? what is the diff between select and cursor ? bith are used for data retrival .. rite?
What Utility is used to migrate DB2 from one release to the next?
What is collection in db2 bind?
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
What is the physical storage length of each of the following DB2 data types: DATE, TIME, TIMESTAMP?
Can All Users Have The Privilege To Use The SQL Statement Select (DML)?
What is the difference between cursor stability and repeatable read isolation levels?
How is a typical db2 batch pgm executed?
What is difference between *omit and *nopass?
How can record locking be achieved in those DB2 versions which do not support it?
COBOL 
