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
49655 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 the sql commands?

1090

Are there any features that are decommissioned in 11g that are not present in 11g?

2065

Will truncate release space?

883

What is the difference between having and a where in sql?

1031

What is sql select statement?

968

What is cold data?

895

Suppose a student column has two columns, name and marks. How to get name and marks of the top three students.

952

What is sql profiler in oracle?

1012

What are the three pl sql block types?

945

Can pl sql procedure have a return statement?

956

How to write pl sql program in mysql command prompt?

1006

What is the primary use of normalization?

937

Does sql use python?

972

Which are the different case manipulation functions in sql?

952

What is scalar data type in pl sql?

1018