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

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

Question Posted / shubham

Answer Posted / shubham

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?

3090

What is the physical storage length of the data types: date, time, timestamp in the db2 database?

1102

What does db2 plan contain?

959

How to access db2 tables in mainframe?

990

What are the full forms of spufi and dclgen and why are they used?

1022

What is consistency token in db2?

1060

What is db2 connect?

1007

What does reorg do in db2?

983

What is image copy in db2?

943

Is db2 relational database?

914

How can you validate Sql errors during cursor operation in db2 pgms and where do you code?

2166

What is dclgen (declaration generator)?

1009

What is a storage group (stogroup)?

1189

Is db2 free?

1035

What is a bind in db2?

980