DBA > Job Interview Questions > COBOL SQL Interview Questions

How do you concatenate the FIRSTNAME and LASTNAM

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

(Continued from previous question...)

How do you concatenate the FIRSTNAME and LASTNAME from EMP table to give a complete name?

SELECT FIRSTNAME || " || LASTNAME FROM EMP;

(Continued on next question...)

Other Job Interview Questions