Select substr(firstname,1,5) as firtname from emp;

How do you retrieve the first 5 characters of firstname column of db2 table emp?

Question Posted / ankit

Answer Posted / ankit

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is database reorganization?

1137

What are packages in db2?

1030

Which isolation level provides highest data integrity?

1133

What is the use of db2 optimizer?

1125

Which is faster delete or truncate?

1143

What are the bind parameters ibm db2?

1061

What does db2 plan contain?

1031

What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?

1283

What is the advantage in De-normalizing tables in DB2?

1192

What is copy pending and check pending in db2?

1009

What is a db2 schema?

1242

Is db2 a programming language?

1060

What is load utility in db2?

1192

Is ibm db2 open source?

1084

What is db2? Explain.

1057