Write a query to extract first 5 characters of a name in the column Stud

Write a query to extract first 5 characters of a name in the column Stud_Name?

Question Posted / manjunath

1 Answers
2585 Views
RBS, I also Faced
E-Mail Answers

Write a query to extract first 5 characters of a name in the column Stud_Name?..

Answer / shubham

select substr(Stud_Name,1,5) from Table;

Is This Answer Correct ?

1 Yes

0 No

Post New Answer

More DB2 Interview Questions

assume ther are 5000 records in a database and want to fetch using cursor. cursor fetches only 3000 records and fetch is not happening for remaining 2000 records. why it happens and how to rectify it

1 Answers TCS,

What is the difference between a package and a plan?

6 Answers Infosys, L&T, Mphasis,

Suppose we have a query for update update table1 set col1 = 'val1' where col2=(select .... from ...) suppose the subquery does not return any record, what will happen to update?

1 Answers IBM,

Where can you declare a cursor in a cobol-db2 program?

0 Answers

List out the three types of page locks that can be held.

0 Answers

DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?

0 Answers

How can the duplicate values be eliminated from db2 select?

0 Answers

What is view db2?

0 Answers

What is db2?