DB2 - Display the LAST_NAME concatenated with DEPARTMENT_ID, separated by a comma and space, and name the column as ‘Employee - Dept’.

Posted by Bandi on 11/30/2013 | Category: Others Interview questions | Views: 1932 | Points: 40

Answer:

SELECT CONCAT( LAST_NAME ,
CONCAT(‘ , ‘ , DEPARTMENT_ID))“Employee – Dept”
FROM EMPLOYEES

Asked In: Many Interviews | Alert Moderator

Bookmark It

< Previous : DB2 - Display the employee LAST_NAME, DEPARTMENT_I ...

Next > : which of the following function calculates the cum ...

More Interview Questions by Bandi

Latest Interview Questions