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
- 46694 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / venkat
select *from emp where floor(months_between
(sysdate,hiredate))=2;
| Is This Answer Correct ? | 6 Yes | 5 No |
Post New Answer View All Answers
Why do we use set serveroutput on?
what is sub-query? : Transact sql
differentiate between float and double. : Sql dba
how to convert character strings to numeric values? : Sql dba
Can a foreign key have a different name?
Can we use insert statement in function?
What is the difference between database trigger and stored procedure?
When you have to use a default "rollback to" savepoint of plvlog?
What is the most restrictive isolation level? : Transact sql
Name the operator which is used in the query for pattern matching?
Can 2 queries be executed simultaneously in a distributed database system?
What is pivot table in sql?
How you can copy a file to file content and file to pl/sql table in advance pl/sql?
How do we accept inputs from user during runtime?
Is it possible to remove child records without removing master table records...the two having pk,fk relationship?
