select *from emp where floor(months_between (sysdate,hiredate))=2;

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.

Question Posted / venkat

15 Answers
49678 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

Please Help Members By Posting Answers For Below Questions

How do you explain an index number?

1021

What is a null value?

1084

How do I run a program in pl sql?

950

Explain how you can copy a file to file content and file to pl/sql table in advance pl/sql?

955

Define implicit and explicit cursors.

1073

What is the most common sql injection tool?

993

What is snowflake sql?

1010

what is union? : Sql dba

964

What is a loop in sql?

935

how to decrement dates by 1 in mysql? : Sql dba

967

How do you rename a table in sql?

1028

column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.

7134

What are two statement types in sql?

1030

How do I clear the screen in sql plus?

982

How does postgresql compare to oracle/db2/ms sql server/informix?

980