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
- 45665 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
What is before and after trigger?
what is the difference between blob and text? : Sql dba
What is tuple in sql?
Explain normalization and what are the advantages of it?
What are different categories of sql commands?
Can we create table in function?
what are the limitations of mysql in comparison of oracle? Mysql vs. Oracle. : Sql dba
Can we rollback delete command?
Is null operator in sql?
What are stored procedures used for?
Lookups are a key component in sql server integration services (ssis). Explain its purpose?
explain advantages of innodb over myisam. : Sql dba
How to run sql functions in pl/sql?
What is pl sql collection?
List the various privileges that a user can grant to another user?
