What are some SQL aggregates and other built-in functions?
- 2 Answers
- 4413 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 the FREE command?
i have an employment table whch has salary,dept,name? i want salary b/w 1000 to 5000 can anyone pls say the query for ths ?
8 Answers Cap Gemini, CGI, EDS, IBM, Satyam, Wipro,
What does db2 blu stand for?
Are views updateable?
What is the physical storage length of timestamp data type?
what is the input to PLAN? what is the input to DBRM?
What is the syntax for FETCH in DB2 ?
Mention the downsides of page level lock.
How to fetch the last row from the table in SQL (db2)?
What is DCLGEN ?
Mention the location where the output received from explain statement is stored.
what's the equivalent Cobol Data type for Decimal(x,y) in DB2? what does the current SQLID register contain?
3 Answers Cap Gemini, Tech Mahindra,
COBOL 
