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

what is the functionality of the function htmlentities? : Sql dba

891

What is sql and db2?

941

What is compute?

1011

what is foreign key? : Sql dba

969

What is the difference between a database and a relational database?

1035

Does truncate remove indexes?

970

what is heap table? : Sql dba

1047

What is an inner join sql?

955

What is the difference between mdf and ndf files?

1061

What is the life of an sql statement?

962

Can %notfound return null after a fetch?

1000

How can triggers be used for the table auditing?

1009

Explain the structure of pl/sql in brief.

1042

What will you get by the cursor attribute sql%found?

899

What is the primary use of normalization?

941