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
How do I add a column to a table in db2?
can we view the access paths created by dbrm ? how ? thx
Discuss about db2 bind?
What is table space in db2?
What is dclgen in db2?
Where can you declare a cursor in a cobol-db2 program?
What is nvl in db2?
How to run db2 command in windows?
Is the primary key a clustered index?
What is db2 connect?
Explain various types of locks in db2?
Is schema the same as database?
What is cursor with hold option in db2?
Name the various locking levels available?
What are the two types of logging in the db2 database? Explain them.