select * from employee where (sysdate-hiredate) <=60

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 / avi007

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

Answer Posted / avi007

select * from employee where (sysdate-hiredate) <=60

Is This Answer Correct ?

6 Yes

3 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What steps server process has to take to execute an update statement?

975

Explain the purpose of %type and %rowtype data types with the example?

994

what are the advantages and disadvantages of views in a database? : Sql dba

1043

How can I speed up sql query?

962

Where not exists in sql?

979

What is the use of <> sql?

980

Where is sql database stored?

982

How do you explain an index number?

1109

Inline the values in PL/SQL, what does it mean.?

1227

Is sql a programming?

972

How much does a sql dba make? : SQL DBA

945

How do you rename a table in sql?

1111

How do I use google cloud in sql?

1088

What is procedure explain with program?

1017

How to know the last executed procedure?

1099