DB2 - Display the LAST_NAME and HIRE_DATE of every employee who was hired in 2006

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

Post |

Interview FAQs |

Exclusive Questions |

Interview Home

Answer:

SELECT LAST_NAME, HIRE_DATE
FROM EMPLOYEES
WHERE YEAR(HIRE_DATE)=2006

SELECT LAST_NAME, HIRE_DATE
FROM EMPLOYEES
WHERE HIRE_DATE LIKE '2006%'

Asked In: Many Interviews | Alert Moderator

Bookmark It

< Previous : DB2 - Display the DEPARTMENT_ID &DEPARTMENT_NA ...

Next > : DB2 - Display the employee LAST_NAME, DEPARTMENT_I ...

Comments or Responses

More Interview Questions by Bandi

DB2 - Display the employee LAST_NAME, DEPARTMENT_ID and HIRE_DATE of e ...
DB2 - Display the LAST_NAME concatenated with DEPARTMENT_ID, separated ...
which of the following function calculates the cumulative distribution ...
what is the output of SELECT CHOOSE (0, 1, 2, 3)?
what is the output of SELECT CHOOSE (0, 1, 2, 3)?
DECLARE @CurrentDate DATETIME = '2012/09/23 10:23PM'; SELECT ...
DB2 - FIND THE NEXT LEAP YEAR using single SELECT statement?
what is resource db in sql server 2008?

Latest Interview Questions

What will happen,if we compile below code public interface intf_per ...
In VB.Net Overloads keyword is used for which type? Public Over ...
What is the best example of Function Overloading?
What will happen,if we compile below function? private double sum(i ...
What will happen,if we compile below function:- private double sum( ...
What will happen,if we compile below function? private double sum(i ...
What are the points which fulfill Function Overloading?
Does Function Overloading depend on Return Type?
More ...