select *from emp where floor(months_between (sysdate,hiredate))=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 / venkat

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

Answer Posted / venkat

select *from emp where floor(months_between
(sysdate,hiredate))=2;

Is This Answer Correct ?

6 Yes

5 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

how is myisam table stored? : Sql dba

1056

What is a procedure in pl sql?

1211

What is the purpose of using pl/sql?

1146

What are the most important characteristics of pl/sql?

1160

Explain the rollback statement?

1013

What types of commands can be executed in sql*plus?

1109

Is left join same as inner join?

1130

What is procedure in pl sql?

1046

What does stand for in sql?

972

Are stored procedures faster than queries?

948

Difference between truncate, delete and drop commands?

1082

Do we need to create index on primary key?

929

What is difference between rank () row_number () and dense_rank () in sql?

1101

what happens when the column is set to auto increment and you reach the maximum value for that table? : Sql dba

1033

Which are the different types of indexes in sql?

1061