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
50182 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 is record variable?

974

what are the features and advantages of object-oriented programming? : Sql dba

998

What are the 3 types of behavioral triggers?

1244

What is the difference between sql and mysql?

1112

What is a string data type in sql?

1029

How many subqueries can be nested in a statement?

978

What are synonyms in sql?

965

what is bcp? When does it used? : Sql dba

982

What is an alias command?

1054

explain about mysql and its features. : Sql dba

1010

What is sql lookup?

913

What is sql table?

961

How do you identify a primary key?

1058

Explain the insert into statements in sql?

998

How to find 3rd highest salary of an employee from the employee table in sql?

1075