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
- 45721 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / venkat
select *from emp where floor(months_between
(sysdate,hiredate))=2;
| Is This Answer Correct ? | 6 Yes | 5 No |
Post New Answer View All Answers
What is procedure and function in sql?
what are the different type of sql's statements ? : Sql dba
how many sql dml commands are supported by 'mysql'? : Sql dba
How do you create a unique index?
What is offset in sql query?
How do I view a sql trace file?
explain about mysql and its features. : Sql dba
What are the two types of exceptions in pl/sql?
what is a control file ? : Sql dba
What are the 3 modes of parameter?
What are string functions in sql?
Explain two easy sql optimizations.
Is stored procedure faster than query?
What is oracle sql called?
Is inner join faster than left join?
