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
- 45707 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / venu
select * FROM(SELECT ENAME, Abs(to_date('&DATE' ,'dd/mm/yy')- HIREDATE) AS DATES FRom EMP) where dates<60;
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What is a temporal table?
what is heap table? : Sql dba
What are the differences between implicit and explicit cursors?
What type of join is sql join?
What are different types of indexes?
What are the two types of periodical indexes?
What is substitution variable?
what is a database? : Sql dba
What is primary key and foreign key with example?
What is difference between inner join and cross join?
what is the difference between union and union all? : Sql dba
Where is sql database stored?
Which is better varchar or nvarchar?
What are keys in sql?
Is sql a scripting language?
