How to list employees names hired AFTER a certain date

I need to list the employees hired after any random date, lets say 10th December 2010 in ascending order and minus their salary by 100% how would I do this?

Showing Answers 1 - 2 of 2 Answers


  • Aug 19th, 2018

Select * from Employee where hiredate between 10/12/2015 and sysdate

  1. SELECT * FROM Employee WHERE hiredate BETWEEN 10/12/2015 AND SYSDATE

  Was this answer useful?  Yes

Pratiksha Chacan

  • Aug 24th, 2019

Select * from employee e where to_char(hiredate, YYYY)=2019;

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.


Related Answered Questions


Related Open Questions