select * from emp where add_months(sysdate ,-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 / xyz

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

Answer Posted / xyz

select * from emp where add_months(sysdate ,-2);

Is This Answer Correct ?

1 Yes

9 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Does sqlite need a server?

1097

What is the difference between subquery and correlated query?

1120

Why do we use joins in sql?

1009

What is partition by in sql?

1132

what is 'mysqlshow'? : Sql dba

1076

What are sql*plus environment variables?

1155

What is a dirty read sql?

1247

What is primary key sql?

1112

Can we insert data into materialized view?

993

What is trigger explain with example?

1093

What is not equal in sql?

1196

Is a secondary key the same as a foreign key?

1120

What is triggering circuit?

1108

What is the purpose of normalization?

1088

Why do we use joins?

1101