Interested to Buy Any Domain ? << Click Here >> for more details...
How is the SUBSTR keyword used in sql?
- 1 Answers
- 9442 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 |
What do you mean by commit and rollback?
What is buffer pool?
What are the different types of base tables?
Explain correlated sub-queries.
What is the use of dclgen in db2?
What does it mean if the null indicator has -1, 0, -2?
What is the difference between Primary key and unique index?
what happend with out using Commit,when closing cursor and program?
What is difference between alias and synonym in db2?
SI Stud name Subject Marks Pass/Fail 1 Sham Maths 40 P 1 Sham Physics 50 P 1 Sham Bio 20 F 2 Ram Maths 40 P 2 Ram Physics 50 P 2 Ram Bio 60 P For the above data , write the SQL query for the student who passed in all the subjects . For eg : I want the data of only Ram coz he passed all subjects .
How does DB2 determine what lock-size to use?
What is the syntax for FETCH in DB2 ?
COBOL 
