Interested to Buy Any Domain ? << Click Here >> for more details...
What are some SQL aggregates and other built-in functions?
- 2 Answers
- 5478 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 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 tell me how can you find out the # of rows updated after an update statement?
How to rename a table in DB2 ?
Can you define an Index if the table size less than 10 PAGES?
How does one remove entries from the SCT02 table?
What are the uses of db2 optimizer?
What are the four lockable units for DB2?
When is the access path determined for dynamic SQL?
Give a brief description of db2 isolation levels?
What if , we failed to mentioed null indicator in sql select query , that may retrieve null value ?
How many buffer pools are there in DB2?
Why do we need to create an alias if we can directly use the table name? What are the benefits of referring a table name by its alias? Also, when should we go for alias and when for synonyms?
COBOL 
