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
50075 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 to look at the current sql*plus system settings?

1138

How many types of functions are there in sql?

933

What is a trigger word?

1005

how many groups of data types? : Sql dba

1002

What is index example?

995

Can we join tables without foreign key?

950

What do we need to check in database testing?

1005

Can we write dml inside a function in sql server?

932

What is plpgsql language?

1041

What are instead of triggers?

1030

What is the difference between delete and truncate statement in sql?

1049

What is auto increment feature in sql?

1111

What is a scalar value in sql?

1059

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

1047

What are local and global Indexes and where they are useful.

1433