Interested to Buy Any Domain ? << Click Here >> for more details...
What are some SQL aggregates and other built-in functions?
- 2 Answers
- 5236 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 |
Write a query to extract first 5 characters of a name in the column Stud_Name?
What is the command used by TSO users to invoke DB2?
Explain correlated sub-queries.
Where is the access path logic created by the DB2 Optimizer stored?
wht steps we need will coding cobol and db2 pgm ?
What are the functions in DB2?
How can you get the number of rows impacted by the last executed query?
Why do we bind in db2?
what is diffrence b/w file-aid tool and file-aid utility???
What is nvl in db2?
Explain db2.
Mention the definition of cobol in varchar field.
COBOL 
