Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / s
Select * from emp
where SUBSTR(empname,4,2) = 'EN'
4 is the starting position and returns 2 characters after
that.
| Is This Answer Correct ? | 8 Yes | 5 No |
Post New Answer View All Answers
What is the role of the data page in the db2 database?
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
How do I delete a column in db2?
What are catalog tables in db2?
Mention the different locking levels that are available in db2.
How would the varchar column remarks defined?
Mention some fields that are a part of sqlca.
Why select is not preferred in embedded sql programs?
What are types of indexes?
What is dbrm in db2 database?
What is runstats utility in db2?
What are the rules for db2 programming?
Describe major components of db2?
What is rebind in db2?
Can you use max on a char column?
