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
- 50185 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / xyz
select * from emp where add_months(sysdate ,-2);
| Is This Answer Correct ? | 1 Yes | 9 No |
Post New Answer View All Answers
How do I run a pl sql program?
How to raise user-defined exception with custom sqlerrm ?
Why partition by is used in sql?
Differentiate between pl/sql and sql?
Can 2 queries be executed simultaneously in a distributed database system?
what is a composite primary key ? : Sql dba
What is sql dialect?
What is the difference between microsoft sql and mysql?
What does trigger mean in psychology?
Why functions are used in sql?
Define commit?
Enlist the characteristics of pl/sql?
List the ways to get the count of records in a table?
Why do we need sharding?
What is procedure and function in sql?
