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

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

More DB2 Interview Questions

why we create view.

How does the processing of a correlated subquery differ from a non correlated subquery?

What techniques are used to retrieve data from more than one table in a single SQL statement?

What is db2 purescale?

When reorg is used?

What error I will get if my select query gives multiple row while executing a Cobol-DB2 program.How can I solve it without using a cursor.

What is the difference between using bind () and rebind () methods of naming class?

What is a buffer pool?

How many types of page locks can be held in db2?

in db2, already 10 columns arie der, and i want to insert 11th column. what parameters u wil consider for insertion and how will u insert

Define declaration generator (dclgen).

What is cloudant database?

For more DB2 Interview Questions Click Here