DB2 - Write a query to get the employee name who joined the company recently (newest employee)

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

SELECT FIRST_NAME AS “Recently joined employeeS”
FROM (SELECT FIRST_NAME,
RANK() OVER( ORDER BY hire_date DESC) RNK FROM EMPLOYEES) WHERE RNK =1


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response