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

what is the difference between normal select query and currosor

What is blu acceleration in db2?

What are the two types of logging in the db2 database? Explain them.

Mention the length of physical storage of the given data types of db2 – date, timestamp, time

What is the physical storage length of the data types date, time, and timestamp?

What is the FREE command?

What is a clustered index?

Which isolation level provides highest data integrity?

How to create a table using embedded sql?

If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?

What are foreign keys?

Is db2 a mainframe?

For more DB2 Interview Questions Click Here