I want to display the employees who have joined in last two
months. (It should be executed randomly means If I execute
the query in March it should display Jan and Feb joined
employees. Same query if i execute in Feb, 2007 it should
display dec, 2006 and jan 2007 joined employees.
- 15 Answers
- 46688 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / sdp
select * from emp
where trunc(months_between(sysdate, hiredate))=2;
| Is This Answer Correct ? | 39 Yes | 14 No |
Post New Answer View All Answers
What is the reports view in oracle sql developer?
what is the difference between join and union? : Sql dba
What is the difference between cross join and natural join?
Which command is used to delete a trigger?
Is null operator in sql?
How can a function retun more than one value in oracle with proper example?
What is sqlcontext?
How consistent is the view of the data between and within multiple sessions, transactions or statements ?
How to get unique records from a table?
What is memory optimized table?
Is sql pronounced sequel or sql?
What is row_number () in sql?
What are its different types of dbms?
What does subquery mean in sql?
Is oracel sql developer written in java?
