Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 50316 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / kesava
100% sure execute
select * from emp
where hiredate between
trunc(add_months(last_day(sysdate),-3)+1) and
trunc(add_months(last_day(sysdate),-1))
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Is left join and outer join same?
what is sql in mysql? : Sql dba
what are the authentication modes in sql server? : Sql dba
What is Difference Between Unique and Primary Key Constraints?
What are records give examples?
What are the methods of filing?
How can we implement rollback or commit statement in a trigger?
What are sql commands?
What is nosql example?
What are pl/sql cursor exceptions?
Should I use mbr or gpt?
How to find 3rd highest salary of an employee from the employee table in sql?
What is the difference between alter trigger and drop trigger statements?
What is sql clause?
List out the acid properties and explain?
