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
50314 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 a common use of group by in sql?

1051

How do you declare a user-defined exception?

1024

What are different types of statements supported by sql?

1165

what is the use of set statement in tsql? : Transact sql

1011

Define SQL and state the differences between SQL and other conventional programming Languages?

1211

Define commit?

1003

how to calculate expressions with sql statements? : Sql dba

1034

How do you modify a table in sql?

1124

Why join is faster than subquery?

1111

Why use stored procedures?

1093

How many commands are there in sql?

1028

What is transaction control language (tcl)?

1139

what is a unique key ? : Sql dba

1091

What jobs use sql?

981

Does oracle roll back the transaction on an error?

1013