select * from emp where hiredate between add

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.

Question Posted / raji_4u

15 Answers
50157 Views
Wipro, I also Faced
E-Mail Answers

Answer Posted / raji_4u

select *
from emp
where hiredate
between add_months(trunc(sysdate,'Month'),-2)
and trunc(sysdate,'Month')-1

This works for sure. 100 %

Is This Answer Correct ?

14 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How many commands are there in sql?

1021

What is Histogram?

1554

What is t-sql? : Transact sql

974

How bulk collect improves performance?

995

What are pl sql data types?

1004

What is date functions?

1024

What is 19 null in sql?

947

What is sql key?

975

What is a sql driver?

992

what is the bond code in materialized view?

2995

What are the different types of joins in sql?

1760

What is the use of %rowtype?

1029

Is clustered index a primary key?

943

What are the 3 types of behavioral triggers?

1244

What is loop in pl sql?

1031