How do you retrieve the first 5 characters of firstname column of db2 table emp?
- 1 Answers
- 1135 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
How do I add a column in db2?
select 100 records from million records ?
What does an outer join do?
What is a db2 package?
Usually, which is more important for DB2 system performance - CPU processing or I/O access?
Name some fields from SQLCA
What is consistency token in db2?
what is the role of the cursor in db2?
How can you find out the # of rows updated after an update statement?
What is null indicator in db2?
what is commit & rollback? When and where is used while compiling a cobol-db2 program?
What are the contents of dclgen?
COBOL 
