What are some SQL aggregates and other built-in functions?
- 2 Answers
- 4785 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 the difference between drop table and delete table?
i have one file having 100 of records? i want to display it like 20 records in one column and 20 records in another column total 40 records per page ? how ?
What is role in db2?
While creating a table, by mistake you have given size of one field as 10. But as per requirement size should be 8. What is your next step?
What is a db2 collection?
What is meant by the attachment facility?
WHAT IS NULL INDICATOR ? WERE IS THIS USED? AND IF IT IS USED IN FILES CONCEPT? HOW DO WE USE IT?
What is schema in db2?
Update command
Can any one tell me about Restart logic in DB2.
how to copy the host variables from ps file into cobol program other than include statement
What is the database descriptor?
COBOL 
