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.
- 15 Answers
- 45785 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
Explain table and field in sql?
How can I change database name in sql?
what is 'mysqlcheck'? : Sql dba
What is a natural join sql?
What is meant by user defined function?
Can we commit in trigger?
What is an example of translating a date into julian format?
Why function is used in sql?
What is varray in pl sql?
What is a sql select statement?
How is data stored in sql?
What does pl sql stand for?
How do I turn a list into a table?
Is not null in sql?
what is commit? : Sql dba
