DB2 - Display the LAST_NAME of all employees where the first letter of the name is ‘S’

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

Answer:

SELECT LAST_NAME
FROM EMPLOYEES
WHERE LAST_NAME LIKE ‘S%’

or

SELECT LAST_NAME
FROM EMPLOYEES
WHERE LEFT(LAST_NAME,1) =‘S’

Asked In: Many Interviews | Alert Moderator

Bookmark It

< Previous : DB2 - Display the LAST_NAME of all employees where ...

Next > : DB2 - Display the DEPARTMENT_ID &DEPARTMENT_NA ...

More Interview Questions by Bandi

Latest Interview Questions