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

How do I delete a trigger?

1015

How do you bind variables in pl sql?

1160

what is blob? : Sql dba

1222

What is the difference between sql and t sql?

1107

Why do we go for stored procedures?

1127

What is normalisation in sql?

1100

Is pl sql still used?

1018

What is $$ in sql?

1046

Is a secondary key the same as a foreign key?

1120

What is forward declaration in pl sql?

1141

What is group function in sql?

1067

What is the use of function in sql?

1152

What is 19 null in sql?

1022

Explain the difference in execution of triggers and stored procedures?

1065

where are cookies actually stored on the hard disk? : Sql dba

1080