select * from temployees where to_char(hiredate, 'month') in

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

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

Answer Posted / pracheth

select * from temployees where to_char(hiredate,
'month') in
(to_char(trunc(sysdate,'month')-30,'month'),to_char(trunc(sysdate,'month')-60,'month'))

Is This Answer Correct ?

0 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What does rownum mean in sql?

1011

How do temporal tables work?

939

Does oracle use sql?

910

What is embedded sql in db2?

996

what is a constraint? : Sql dba

1126

What are types of joins?

949

What are inner outer left and right joins in sql?

998

what is the stuff function and how does it differ from the replace function? : Sql dba

1031

how to convert character strings to numeric values? : Sql dba

1080

Does sql full backup truncate logs?

1008

Is sqlite free?

950

How do I start sql from command line?

1002

What is database white box testing and black box testing?

1095

what is a stored procedure? : Sql dba

1109

Why is theta join required?

1125