select * FROM(SELECT ENAME, Abs(to

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 / venu

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

Answer Posted / venu

select * FROM(SELECT ENAME, Abs(to_date('&DATE' ,'dd/mm/yy')- HIREDATE) AS DATES FRom EMP) where dates<60;

Is This Answer Correct ?

0 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are sql triggers used for?

980

how to use case expression? : Sql dba

998

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

989

Define join and name different types of joins?

987

What is a sql statement?

938

What is synonyms?

1037

What is the use of function in sql?

1067

explain access control lists. : Sql dba

978

What is dense_rank?

923

what is auto increment? : Sql dba

992

Why is sql better than hql?

970

What is a null value?

1124

What is an implicit commit?

1037

what are the advantages of mysql in comparison to oracle? : Sql dba

987

what is a trigger? : Sql dba

1008