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

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

Answer Posted / shubham

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

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is the syntax for creating a table in the db2 database?

1073

What is database reorganization?

1074

What is the use of value function?

1095

What is an instance in db2?

1002

What is view db2?

1024

What is db2?

1137

How to run db2 command in windows?

1156

What is db2 catalog database?

999

What is dbrm?

1054

Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?

8174

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

2882

What is query_cache_limit?

939

List out the data types available.

1104

What does db2 mean?

969

Explain the function done by data manager?

1234