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

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is phantom read in db2?

720


How to find the number of rows in db2 tables?

699


What is bind and rebind in db2?

739


List some fields from sqlca?

682


What are packages in db2?

689






Is ibm db2 free?

664


Define db2 and its databases?

708


What is a storage group (stogroup)?

868


What is scrollable cursor in db2?

691


What is database alias db2?

695


What is sqlca?

705


How is deadlock resolved?

744


Why do we use cursor?

681


What is meant by explain?

742


What are bind parameters in db2?

693