What are some SQL aggregates and other built-in functions?

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


Please Help Members By Posting Answers For Below Questions

What is a page in db2?

692


What is a db2 tablespace?

690


What is rct?

847


What is explain in db2?

657


have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.

1362






How can we read records for specific member in CL? AND rpg?

324


What is the use of db2 optimizer?

696


Define db2 and its databases?

708


What is the syntax for FETCH in DB2 ?

769


What is null indicator in cobol db2?

677


What is the information associated with sysibm.syslinks table?

756


What are the prerogatives?

703


B37 abend during spufi?

1086


How do I add a column to an existing table in db2?

681


Which is faster delete or truncate?

769