select * from emp where round(months_between(sysdate,hire

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

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

Answer Posted / satish

select * from emp where
round(months_between(sysdate,hire_date) in(1,2);

Is This Answer Correct ?

0 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How are functions and procedures called in PL/SQL?

1236

Do foreign keys improve performance?

1027

Why do we use function in pl sql?

1065

What are some predefined exceptions in pl/sql?

1171

What is a pdo connection?

1045

What are the different set operators available in sql?

1026

What is raid? How does it help storage of databases?

1087

How do we use distinct statement? What is its use?

1033

Explain how exception handling is done in advance pl/sql?

999

What jobs use sql?

985

Does google use sql?

968

Can ddl statements be used in pl/sql?

1145

Does access use sql?

1045

what is union? : Sql dba

1030

What is union and union all keyword in sql?

1044