Join_date is the column in Emp table. select * from emp where join

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

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

Answer Posted / test

Join_date is the column in Emp table.

select * from emp
where join_date between sysdate and sysdate - 60

Is This Answer Correct ?

2 Yes

11 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Which software is used for pl sql programming?

986

What is pl sql package?

1031

What is dbo in sql?

962

Can we use having without group by in sql?

982

Define join and name different types of joins?

1008

Does a user_objects view have an entry for a trigger?

1011

How do you drop a trigger?

989

What is sql*loader and what is it used for? : aql loader

1174

What are the advantages of indexing?

985

How do I quit sql?

957

Write a unique difference between a function and a stored procedure.

996

How can we make an if statement within a select statement?

1013

What is trigger with example?

1099

what is the difference between $message and $$message? : Sql dba

997

Which nosql database is best?

975