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?
  • Interview Candidate
  • 9
  • 8057

Showing Answers 1 - 9 of 9 Answers

Shashank

  • Aug 19th, 2018
 

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

Code
  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

Pendo

  • Jul 17th, 2021
 

SELECT * FROM Employees WHERE CAST(DATE AS DATE)>20101210

  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