What are some SQL aggregates and other built-in functions?
- 2 Answers
- 4801 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 validate Sql errors during cursor operation in db2 pgms and where do you code?
What is a db2 schema?
Define sqlca.
Where can you declare a cursor in a cobol-db2 program?
Are views updateable?
How to find primary key of a table in db2?
What is the connection string to connect to the DB2 Database ?
what are bind concepts in db2 cobol?
run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...
What is a db2 table?
What is the use of commit in db2?
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
What is the difference between db2 and oracle?
What are the two types of logging in the db2 database? Explain them.
What is temporal table in db2?
