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
Please Help Members By Posting Answers For Below Questions
Why cursor is used in db2?
How do you stop a db2 database in linux?
What does reorg do in db2?
What is access path in db2?
What is null in db2?
How to find schema of a table in db2?
Is db2 a database?
How do I change the column size in db2?
Who uses db2?
How do I create a view in db2?
What do you mean by commit and rollback?
What is meant by explain?
How to find the maximum value in a column in the db2 database?
How do you select a row using indexes in db2?
What is bind in db2?
