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

Write a sql query to get the third highest salary of an employee from employee_table?

1077

Is hadoop a nosql?

1008

What is a join?

1075

What is scope and visibility in PL/SQL?

1210

how many sql ddl commands are supported by 'mysql'? : Sql dba

1028

How do I view a view in sql?

956

Are left and right joins the same?

1091

Is left join faster than inner join?

1129

How do you get column names only for a table (sql server)?

1170

What is database migration?

973

what are all the different types of indexes? : Sql dba

1051

what are date and time intervals? : Sql dba

1062

How do I remove duplicates in two columns?

1078

Differentiate between pl/sql and sql?

1155

How many joins in sql?

1017