Interested to Buy Any Domain ? << Click Here >> for more details...
What are some SQL aggregates and other built-in functions?
- 2 Answers
- 5396 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 tablespace?
what is contained in the DB2 node lock file? A) data base names B) data base users names C) license keys D) server names
What is the maximum number of tables that can be stored on a Partitioned Table Space ?
Compare a subselect to a join?
What are the 4 environments which can access DB2 ?
What is ALTER ?
I have a DB2 table which has 1000 rows.after udatingg first 110 rows, my job abends. Now what I have to do if I want to restart the job next time so that it should start updating from 111th row (without updating first 110 rows again).
What is the difference between dbm cfg and db cfg file in db2 ?
Is it possible to create an Instance in DB2 using DB2 Control Center ?
What if we try to insert the base table through updatable view , but failed to give a column value which is defined as NOT NULL.
Can you use a select query in a loop to fetch multiple rows? If so what is the advantage of using a cursor?
How to execute stored procedure in db2 command editor?
COBOL 
