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
- 45808 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
What does pragma mean?
what are the different tables present in mysql, which type of table is generated when we are creating a table in the following syntax: create table employee (eno int(2),ename varchar(10)) ? : Sql dba
What does cursor do in sql?
How do you optimize a stored procedure query?
Explain what is table in a database?
Why is %isopen always false for an implicit cursor?
How many commands are there in sql?
What are the three pl sql block types?
Can we commit in trigger?
What do you mean by stored procedures?
What is the difference between view and stored procedure?
how to run 'mysql' commands from a batch file? : Sql dba
How do I clear the screen in sql plus?
what is heap table? : Sql dba
Mention what pl/sql package consists of?
