Can you Average the Characters ?
Answers were Sorted based on User's Feedback
Answer / sudhakar
No will get an Error -
-420
The value of a string argument was not acceptable to the function-name function
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / naveen87ginjupalli
Yes,we can Average the characters
SELECT AVG(EMP-NAME) FROM EMP;
Is This Answer Correct ? | 4 Yes | 9 No |
Shall i use this query to retrieve first 4 records, Select empno, sal from emptbl where empno < 5. like this can we fetch first 100 records?
What is the difference between Primary key and unique index?
Why select is not preferred in embedded sql programs?
Is it possible using max on a char column?
Select empno, sal from emptbl where empno < 101.By this query can we fetch first 100 recs? where empno is primary key.It won't throw -811 error? if it wont,then what is use of cursor technique while fetching first 100 recs. Please need more clarification.
What is universal database?
What is read-only cursor?
What is the purpose of coding FETCH in a SQL SELECT query? Explain with an example in Detail?
Who uses db2?
Explain about cursor stability?
Can there be more than one cursor open for any program?
What is explain plan in db2?