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
50082 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 and explain the different types of join clauses supported in ansi-standard sql?

1346

What is the current version of postgresql?

1051

What is duration in sql profiler trace?

1066

what is sql? : Sql dba

1006

Can we use the cursor's to create the collection in PL/SQL?

1008

Is t sql a programming language?

1050

How do you remove duplicates without using distinct in sql?

965

How do I access sql anywhere database?

954

What are the basic techniques of indexing?

1052

Why do we need cursors in pl sql?

1062

How do I trace sql profiler?

959

Does sql profiler affect performance?

980

What sql database should I use?

1125

What is loop in pl sql?

1023

What are the types of optimization?

933