> > >

DB2 Programming MCQs

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

SELECT concat(FIRSTNAME LASTNAME) FROM EMPLOYEE;

SELECT FIRSTNAME || ' ' || LASTNAME FROM EMPLOYEE;

SELECT "FIRSTNAME" ||"LASTNAME" FROM EMPLOYEE;

SELECT 'FIRSTNAME ||LASTNAME' FROM EMPLOYEE;<br>

Answer

Correct Answer: SELECT FIRSTNAME || ' ' || LASTNAME FROM EMPLOYEE;

Explanation:

Note: This Question is unanswered, help us to find answer for this one

DB2 Programming Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it