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

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

How do I optimize a query in db2?

822


What is null indicator in cobol db2?

774


What are the prerogatives?

800


How to find schema of a table in db2?

744


What is dclgen in db2?

879


What is isolation level in db2?

753


What language is db2 written in?

777


How can we read records for specific member in CL? AND rpg?

437


How to resolve deadlock issue

18991


What is meant by dclgen?

843


What is the use of reorg in db2?

817


What is db2 connect?

785


If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2

1790


can we view the access paths created by dbrm ? how ? thx

6639


Why do we need reorg in db2?

733