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
- 50742 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
What is the main difference between sql and pl/sql?
Why do we need databases?
How do I edit a stored procedure?
what does myisamchk do? : Sql dba
Can you call pl/sql package functions from within a fast formula?
Can we change the table name in sql?
What is pl sql in oracle?
What are variables in pl sql?
Can we join more than 2 tables in sql?
Is sqlexception checked or unchecked?
What is dml and ddl?
How does stored procedure reduce network traffic?
Which nosql database is best?
Is it possible to link two groups inside a cross products after the cross products group has been created?
what is the syntax for using sql_variant_property? : Transact sql
