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

What are the two characteristics of a primary key?

961

what is “go” in t-sql? : Transact sql

1090

How to set up sql*plus output format in oracle?

1021

What is a unique key?

1037

Which tcp/ip port does sql server run?

991

Why do we use sqlite?

957

Explain what is a database?

1078

What does trigger mean in slang?

1036

How do I remove sql plus from windows 10?

1079

what are the different functions in sorting an array? : Sql dba

1005

what is the syntax for using sql_variant_property? : Transact sql

1026

What is sql*loader?

1161

what is difference between delete and truncate commands? : Sql dba

1109

What is the use of index in hive?

992

Difference between truncate, delete and drop commands?

1067