Interested to Buy Any Domain ? << Click Here >> for more details...
What are some SQL aggregates and other built-in functions?
- 2 Answers
- 5469 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 |
why we go for SPUFI for creating tables or for sql queries?
what will be the output of the below given query, if no matching records are found : (a.) 0 (b.) null (c.) error select Avg(salary) from TableA where Deptno = 'insurance'
What is load replace in db2?
Highlight all the advantages that are attached to a package.
What is the syntax for FETCH in DB2 ?
What is a DB2 bind?
What's The Error Code For Unique Index Voilation?
Can you tell me how can you find out the # of rows updated after an update statement?
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
How do I add a column in db2?
Are views updateable?
How do I create a view in db2?
COBOL 
