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

List the ways to get the count of records in a table?

900

Can a table contain multiple primary key’s?

1098

What do you understand by pl/sql cursors?

1086

What is a sql trace file?

1026

What is aggregate function in sql?

1036

How do I start pl sql?

946

What jobs use sql?

981

What are aggregate functions in sql?

1160

What is ttitle and btitle?

1063

What is sql exception?

974

Is oracle and sql same?

1009

Which is faster joins or subqueries?

991

What is pl sql block in dbms?

1003

What are the benefits of stored procedures?

1072

Is natural join same as inner join?

940