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: 630 | 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 

Comments or Responses

Login to post response