Can you Average the Characters ?

Answers were Sorted based on User's Feedback



Can you Average the Characters ?..

Answer / knight

will return sqlcode= -171

Is This Answer Correct ?    2 Yes 0 No

Can you Average the Characters ?..

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

Can you Average the Characters ?..

Answer / naveen87ginjupalli

Yes,we can Average the characters
SELECT AVG(EMP-NAME) FROM EMP;

Is This Answer Correct ?    4 Yes 9 No

Post New Answer

More DB2 Interview Questions

where can we use index and subscript ? with example ?

3 Answers   CTS,


Which command is used to remove all rows from a table?

1 Answers  


What is buffer pool in the db2 database?

1 Answers  


What is data manager?

1 Answers  


I want to fetch the 10th row of a table which has been changed.How can I do it without going thru all the rows.

5 Answers  


When do you specify the isolation level? How?

1 Answers  


How many databases are there?

1 Answers  


Give some example of statistics collected during RUNSTATS?

1 Answers  


List out the three types of page locks that can be held.

1 Answers  


How many buffer pools are available in db2?

2 Answers  


what is the difference between where clause and having clause

2 Answers   IBM,


How is a typical db2 batch pgm executed?

1 Answers  


Categories