Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to retrive partial string.
- 2 Answers
- 5825 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / rajesh_m13
substr('string',1,3) which gives str. correct me if i am wrong
| Is This Answer Correct ? | 8 Yes | 0 No |
Answer / ignatius pradeep
A Sample Query:
SELECT SUBSTR(DESC_T,1,4)
FROM PRODUCT
WHERE PROD_I = 123456;
DESC_T is a column in the table PRODUCT
The first four characters of the DESC_T will be displayed.
| Is This Answer Correct ? | 4 Yes | 0 No |
how can you access index
What is performance tuning db2?
What is the use of commit in db2?
I am having n number of records in a table which consists of emp-name is one of the field among them. Now i want to change the first letter of every name with capital.
I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?
what is SPUFI ?
What types of tables are there in the db2 database?
Is it mandatory to use DCLGEN? If not, why would you use it at all?
Is DECLARE TABLE in DCLGEN necessary? Why it used?
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 .
What is coalesce in db2?
What is the role of data manager in the db2 database?
COBOL 
