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

Which is faster subquery or join?

1202

What is pl sql package?

1029

Mention what problem one might face while writing log information to a data-base table in pl/sql?

1221

What is procedure and function?

967

What is sql stand for?

979

Is record in oracle pl sql?

953

what is the syntax for using sql_variant_property? : Transact sql

1034

What will you get by the cursor attribute sql%notfound?

1051

What is transaction control language (tcl)?

1128

What is procedure explain with example?

947

What are the different type of joins in sql?

943

Is join and inner join the same?

998

How to get each name only once from an employee table?

1108

What is rename in sql?

964

Mention what does plv msg allows you to do?

1107