select * from af where 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 / suneel

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

Answer Posted / suneel

select * from af where months_between(sysdate,hiredate)<=2

Is This Answer Correct ?

16 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

what is bcp? When does it used? : Sql dba

988

Can sql function call stored procedure?

1018

Can we rename a column in the output of sql query?

993

Explain the difference between rename and alias?

1010

What is the difference between distinct and unique in sql?

946

Can we use views in stored procedure?

1031

Is hadoop a nosql?

1003

How do I start pl sql?

946

What is the primary use of normalization?

1002

How to test for null values?

1046

What is posting?

1035

What is the use of desc in sql?

977

What is database sql?

1048

Define tables and fields in a database

1130

What is lexical units in pl sql?

1146