Interested to Buy Any Domain ? << Click Here >> for more details...
How is the SUBSTR keyword used in sql?
- 1 Answers
- 9237 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 |
How to resolve -818 sql code in DB2?
What is a clustering index ?
What is sqlca’s maximum length?
This was related to -811 sqlcode, In a COBOL DB2 program which accesses employee table and selects rows for employee 'A', it should perform a paragraph s001-x if employee 'A' is present. In this case it gets -811 sqlcode, but still it process the paragraph s001-x. What could be wrong in my code.
Is db2 relational database?
Is it possible using max on a char column?
What is the role of the data page in the db2 database?
Explain correlated sub-queries.
can all users have the privilage to use the sql statement select * (dml)?
Can a Db2 table data be retrived through JCL?
What is collection in db2 bind?
before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?
COBOL 
