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

How do I delete a table in database?

1016

What is innodb buffer pool?

1045

What is a db2 tablespace?

1059

What is copy pending and check pending in db2?

994

What are types of indexes?

1060

Is db2 a mainframe database?

992

What is cobol db2?

991

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

1065

What is concurrency?

1223

How do I import a csv file into db2?

980

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

1085

What is check constraint in db2?

1072

Why do we need reorg in db2?

981

What does db2 plan contain?

1014

Name the lockable units in DB2?

1124