Interested to Buy Any Domain ? << Click Here >> for more details...
How do you retrieve the first 5 characters of firstname column of db2 table emp?
- 1 Answers
- 2135 Views
- I also Faced
- E-Mail Answers
How do you retrieve the first 5 characters of firstname column of db2 table emp?..
Answer / ankit
Select substr(firstname,1,5) as firtname from emp;
| Is This Answer Correct ? | 0 Yes | 0 No |
More DB2 Interview Questions
What is the picture clause of the null indicator variable?
How do I delete a table in db2?
How many types of page locks can be held in db2?
What is filter factor?
what is the name of the default db2 catalog database?
how to resolve -805 . how to see dbrm and package not found
how do u update the faltfile into db2 table ?
What information is used as input to the bind process?
What is a NULL value? What are the pros and cons of using NULLS?
When is the access path determined for dynamic SQL?
What is precompiler in db2?
What is tablespace?
COBOL 
