DBA > Job Interview Questions > DB2 INTERVIEW QUESTIONS

How do you retrieve the first 5 characters of FI

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

How do you retrieve the first 5 characters of FIRSTNAME column of DB2 table EMP ?

SQL Query : SELECT SUBSTR(FIRSTNAME,1,5) FROM EMP;

(Continued on next question...)

Other Job Interview Questions