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

What can you do with pl sql?

1145

What are the key differences between SQL and PL SQL?

1286

Explain the structure of pl/sql in brief.

1142

Can we create view in stored procedure?

1026

How does sql profiler work?

1065

What are literals in sql server?

1260

what is normalization? : Sql dba

1137

What is count * in sql?

1040

what are the differences among rownum, rank and dense_rank? : Sql dba

1087

How do you write a subquery?

1070

How do I delete a trigger?

1015

Does oracle use sql?

992

what are numeric data types? : Sql dba

1111

What is a stored procedure in sql with example?

1204

What are the usages of sql?

1103