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
50176 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

What is nosql vs sql?

1172

Can we use two order by clause in query?

959

What are the set operators in sql?

1065

What are some predefined exceptions in pl/sql?

1157

Compare sql & pl/sql

1120

What is pl/sql language case sensitive?

1107

how to show all tables with 'mysql'? : Sql dba

1106

What is scalar function?

1044

What are different clauses used in sql?

1112

What is difference between stored function and application function?

1187

How do you know if a relationship is 2nf?

933

how to check server status with 'mysqladmin'? : Sql dba

1067

What are all the common sql functions?

1007

What is tuple in sql?

1060

What is a variable in sql?

994