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
- 50067 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 are the two types of exceptions in pl/sql?
What does count (*) mean in sql?
What is difference between pl and sql?
Explain scalar functions in sql?
What does pl sql developer do?
what is innodb? : Sql dba
What type of database is cloud sql?
What are its different types of dbms?
How do I run pl sql in sql developer?
What is record data type?
What is Histogram?
Can we call a function containing dml statements in a select query?
what is the syntax used for partition in tsql? : Transact sql
explain the difference between delete , truncate and drop commands? : Sql dba
Does access use sql?
