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
- 2136 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
What is the maximum size of a char data type in db2?
What is the maximum No of rows per page?
What are the various isolation levels possible?
How to check sequence on a table in db2?
What is declare cursor?
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
What is the use of db2 optimizer?
What is the physical storage length of timestamp data type?
What are db2 objects?
What is the use of db2?
Mention the location where the output received from explain statement is stored.
How do I connect my db2 database to ibm?
What is check constraint in db2?
What is db2 and what is the use of db2 optimizer?
What is db2 bind?
