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
50076 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 is a boolean in sql?

967

In what condition is it good to disable a trigger?

998

What is assignment operator in pl sql?

1018

table structure: ---------------- col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 01-mar-2012 11:12:46 01-mar-2012 11:11:23 Write a query to display the result as shown below: col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10

4254

Can sql developer connect to db2?

1018

What is replication id?

923

What is the need of a partition key?

976

How does postgresql compare to "nosql"?

1020

Why cannot I use bind variables in ddl/scl statements in dynamic sql?

1185

how to enter numeric values as hex numbers? : Sql dba

1049

What is int identity in sql?

1116

What is acid property in a database?

1020

What is exit statement?

1005

Is vs as in pl sql?

971

Does pl/sql support create command?

1088