DB2 - Display the employee details who are working from more than 1 and half year

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

Post |

Interview FAQs |

Exclusive Questions |

Interview Home

Answer:

SELECT * FROM EMPLOYEES WHERE DAYS (CURRENT_DATE)-DAYS (HIRE_DATE) >548

(OR)

SELECT * FROM EMPLOYEES WHERE HIRE_DATE < (CURRENT_DATE - 1 YEARS - 6 MONTHS)

Asked In: Many Interviews | Alert Moderator

Bookmark It

< Previous : What is the correct HTML for referring to an exter ...

Next > : DB2 - Fetch the current date and time in the follo ...

Comments or Responses

More Interview Questions by Bandi

DB2 - Fetch the current date and time in the following format 24/APR ...
DB2 - Find the NAMEs that have an even number of letters in them
DB2 - Find the count of departments having average salary greater than ...
DB2 - Write a query to get the employee name who joined the company re ...
DB2 - Write a query to get the employee name who joined the company re ...
DB2 - Display number of employees in each department, if the departmen ...
DB2 - Display minimum salary from each department
DB2 - Write a query to display employee name who gets highest salary

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 ...