select * from emp where trunc(months_between(sysdate, hiredate))=2;

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 / sdp

15 Answers
50334 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

Please Help Members By Posting Answers For Below Questions

What are different types of keys?

1106

Explain commit, rollback and savepoint.

1002

is it possible to pass an object or table to a procedure as an argument?

1135

How many types of cursors supported in pl/sql?

1193

Which tcp/ip port does sql server run?

1009

How can you load microsoft excel data into oracle? : aql loader

1174

How can I tell if sql is running?

1066

What's the difference between inner join and left join?

1000

What is a string data type in sql?

1045

Explain what is a subquery ?

1189

How does cross join work in sql?

1018

Can a table have no primary key?

1064

Is nosql faster than sql?

1024

what is an index? : Sql dba

998

What is parallel hint?

1328