select * from emp where trunc(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 / sdp

15 Answers
49685 Views
Wipro, I also Faced
E-Mail Answers

Answer Posted / sdp

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

Is This Answer Correct ?

39 Yes

14 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to read/write files from pl/sql?

992

how can we know the count/number of elements of an array? : Sql dba

1004

What are literals in sql server?

1071

What is use of package in pl sql?

949

Show how functions and procedures are called in a pl/sql block.

1041

What is the need of a partition key?

941

What is t sql used for?

972

Can I copy :old and :new pseudo-records in/to an oracle stored procedure?

1142

What are the ddl commands?

948

what are the different tables present in mysql? : Sql dba

923

What is sql dialect?

1036

How many types of triggers are there in pl sql?

1011

What are the advantages of indexing?

927

What are three advantages to using sql?

959

what are the authentication modes in sql server? : Sql dba

998