Interested to Buy Any Domain ? << Click Here >> for more details...
What are some SQL aggregates and other built-in functions?
- 2 Answers
- 5263 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 a view? Why use it?
What is index in db2?
Request to database but database is not available so what is was abend is raised?
Name some fields from SQLCA
What is deadlock in db2?
pls tell me abt the normalization five types....
Plan is an executable form of sql statements,But what exactly resides inside a Plan. what are the details inside Plan.
How to get Top 10 Salaries from a Table
Is it Possible to read from PS file and write it to database by using dynamic sql(execute immediate)
What are the various isolation levels possible?
how can u understand the end of the table ?
What information can you find in SYSIBM.SYSLINKS table?
COBOL 
