Interested to Buy Any Domain ? << Click Here >> for more details...
How is the SUBSTR keyword used in sql?
- 1 Answers
- 9316 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
Discuss about db2 bind?
what is SMP/E? and what are the major steps of it? thanks...
What is load utility in db2?
Is db2 a mainframe?
What's the maximum number of characters that a tablename can have?
db2 restart logic ?
How can record locking be achieved in those DB2 versions which do not support it?
How to know the primary key of a table without defining the primary key in the table?
Can we install 2 different versions of Db2 on same mainframe?
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
0 Answers ITC Infotech, Syntel,
What are the three types of page locks that can be held?
In terms of DB2 indexing, what is the root page?
COBOL 
