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
- 46693 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
What pl/sql package consists of?
What is a relationship and what are they?
What is not null in sql?
Is id a reserved word in sql?
What are the different tcl commands in sql?
What is range partitioning?
What is the main difference between sql and pl/sql?
when MSQL8.0 is in market
what are null values? : Sql dba
Explain select statements in sql?
How show all rows in sql?
Mention what does plv msg allows you to do?
How do you define a foreign key?
How do you delete duplicates in sql query using rowid?
what is sql server agent? : Sql dba
