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
50759 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

What is record variable?

1043

What does pl sql stand for?

1156

What is sap sql anywhere?

1168

What is the difference between unique and primary key constraints?

1122

Why stored procedure is better than query?

1003

How can you fetch common records from two tables?

1106

What are the possible values for the boolean data field?

1016

What is indexes?

1118

How does cross join work?

1008

How can one get sql*loader to commit only at the end of the load file? : aql loader

1119

what is a cursor? : Sql dba

1066

what is 'mysqlcheck'? : Sql dba

1067

What is crud sql?

1030

What is set serveroutput on in pl sql?

1361

Explain the update statement in sql

1046