What are some SQL aggregates and other built-in functions?
- 2 Answers
- 4584 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 |
How does DB2 store NULL physically?
In which column of which DB2 catalog would you find the length of the rows for all tables?
What is a lock?
What is ibm db2 used for?
In a single table,How to retrieve a employee-id of an employee who works in more than one department?
What is a predicate?
What is plan in cobol db2?
What is the result of open cursor statement?
Suppose there are many duplicate records in a Db2 table. What is the query to retrive only duplicate records?
What is a Foreign Key?
0 Answers Tavant Technologies, Zensar,
What are the prerogatives?
How do you simulate the EXPLAIN of an embedded SQL statement in SPUFI/QMF? Give an example with a host variable in WHERE clause)
COBOL 
