100% sure execute select * from emp where hiredate between trunc(add

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

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

Answer Posted / kesava

100% sure execute

select * from emp
where hiredate between
trunc(add_months(last_day(sysdate),-3)+1) and
trunc(add_months(last_day(sysdate),-1))

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How many types of functions are there in sql?

933

What is trigger in pl sql?

982

how would concatenate strings in mysql? : Sql dba

1069

what is the difference between char_length and length? : Sql dba

1028

Explain what is sql?

1100

Can we commit inside a trigger?

981

How many sql databases can you have on one server?

1064

define sql delete statement ? : Sql dba

1003

Is truncate ddl or dml?

978

what is user defined functions? : Sql dba

1019

What is procedure function?

1044

Why truncate is faster than delete?

1090

What are the packages in pl sql?

1002

What is trigger in sql? Explain

976

How is data stored in sql?

1043