Oracle SQL Interview Questions

Write a SQL query to display the employee joined between two dates

Solution

select DISTINCT first_name,last_name from HR.employees where hire_date between '12-JUN-03' and '21-MAY-07';