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
- 45660 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / avi007
select * from employee where (sysdate-hiredate) <=60
| Is This Answer Correct ? | 6 Yes | 3 No |
Post New Answer View All Answers
How many triggers can be applied on a table?
Why do we use triggers?
How many joins can you have in sql?
What is sql*loader?
How do I get sql certification?
What is difference between stored function and application function?
Mention what are different methods to trace the pl/sql code?
What is the difference between null value, zero, and blank space?
What does count (*) mean in sql?
table structure: ---------------- col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 01-mar-2012 11:12:46 01-mar-2012 11:11:23 Write a query to display the result as shown below: col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
Explian rowid, rownum?
Do we need to rebuild index after truncate?
what is cross join? : Sql dba
How many columns should be in an index?
How to get each name only once from an employee table?
