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
50204 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 is primary and foreign key?

1058

Explain what is sql?

1109

What are different types of statements supported by sql?

1159

What are the different type of joins in sql?

945

What is minus?

986

What is materialized view in sql?

916

Is a secondary key the same as a foreign key?

1028

what is a database lock ? : Sql dba

1160

what is a cursor? : Sql dba

1019

What is prepared statement in sql?

1044

What is the maximum number of rows in sql table?

1021

How many primary keys can a table have?

1003

What is t sql in sql server?

1066

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

1201

If a cursor is open, how can we find in a pl/sql block?

1159