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
- 49669 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
How is a PL/SQL code compiled?
What is pessimistic concurrency control? : Transact sql
How do I create a memory optimized filegroup?
Which one is better sql or oracle?
What does trigger mean in psychology?
Can we insert data into materialized view?
What are all the different normalization?
Is vs as in pl sql?
What is restrict in sql?
what is normalization? : Sql dba
How can you create an empty table from an existing table?
What is normalisation and its types?
what is the stuff function and how does it differ from the replace function? : Sql dba
what are the advantages and disadvantages of views in a database? : Sql dba
Explain what is an index?
