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

define clustering index.

1028

What is catalog database in db2?

1165

File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?

2942

When reorg is used?

1129

Explain packages.

1113

is it compulsory commitment control in journal?

2478

Highlight all the advantages that are attached to a package.

1119

How to access db2 tables in mainframe?

1054

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

1074

What is copy pending status in db2?

1127

What is load utility in db2?

1181

What is the maximum size of a char data type in db2?

1011

What is the function of logging in the db2 database?

1123

What is the role of data manager in the db2 database?

1109

Which component is used to execute the sql statements?

1096