How do you retrieve the first 5 characters of firstname column of db2 table emp?
- 1 Answers
- 1152 Views
- I also Faced
- E-Mail Answers
Answer Posted / ankit
Select substr(firstname,1,5) as firtname from emp;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Please Help Members By Posting Answers For Below Questions
What is ibm db2 database?
Define sqlca.
What is dbrm? When it will be created?
What's The Percentage Free Space ?
What is the default page size of buffer pools?
What is the role of union all and union
What is buffer pool?
What is the usage of open cursor command?
How do I delete a table in database?
What is a db2 package?
What is clone table?
Define predicate?
What is the purpose of using commit?
What is a trigger in the db2 database?
What is null indicator in cobol db2?
