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
- 45819 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / suneel
select * from af where months_between(sysdate,hiredate)<=2
| Is This Answer Correct ? | 16 Yes | 2 No |
Post New Answer View All Answers
Define join and name different types of joins?
Why left join is used in sql?
what is the difference between clustered and non clustered index in sql? : Sql dba
What are different functions in sql?
what are the differences between char and nchar? : Sql dba
How do you exit in sql?
What is the difference between join and natural join?
What is structural independence and why is it important?
Explain what is sql*plus?
What is the difference between inner join and natural join?
What are the three forms of normalization?
Why do we use procedures?
What is union?
Why do we need cursors in pl sql?
Does a primary key have to be a number?
