Interested to Buy Any Domain ? << Click Here >> for more details...
How is the SUBSTR keyword used in sql?
- 1 Answers
- 9437 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 can you count the number of rows from a table tab?
What is the role of data manager in the db2 database?
What are the contents of a dclmgen?
What are the isolation levels possible ?
if one db2 pgm calls another db2 pgm. how many plans do we need. what r the steps involved..
What is dbrm in db2 database?
In my table having 100 Rec. How can I delete the 7th row?? (we don't know what is data inside the table)
What is a db2 cursor?
i want to know how the commit option works,how it save the changes? it will update the database or what ? where we can see these saved changes?
What is the difference between a package and a plan?
6 Answers Infosys, L&T, Mphasis,
What is package in cobol db2?
Describe the elements of the SELECT query syntax?
COBOL 
