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
- 50183 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / avi007
select * from employee where (sysdate-hiredate) <=60
| Is This Answer Correct ? | 6 Yes | 3 No |
Post New Answer View All Answers
what are the different index configurations a table can have? : Sql dba
how can we submit a form without a submit button? : Sql dba
What is the difference between an inner join and an outer join?
What are actual parameters and formal parameters?
Explain commit, rollback and savepoint.
Is it possible to sort a column using a column alias?
Define join and name different types of joins?
Is sql a oracle?
What is a natural join?
what tools available for managing mysql server? : Sql dba
Explain the select statement in sql?
Is natural join and inner join same?
How can you load microsoft excel data into oracle? : aql loader
Can we use the cursor's to create the collection in PL/SQL?
How can one get sql*loader to commit only at the end of the load file? : aql loader
