Answer / sdp

select * from emp
where trunc(months_between(sysdate, hiredate))=2;

Answer / suneel

select * from af where months_between(sysdate,hiredate)<=2

Answer / raji_4u

select *
from emp
where hiredate
between add_months(trunc(sysdate,'Month'),-2)
and trunc(sysdate,'Month')-1

This works for sure. 100 %

Answer / avi007

select * from employee where (sysdate-hiredate) <=60

Answer / arijit

take Mon(like sep,oct,mar etc)
and year( like 2006,2007,1980 etc) as input...
and execute this query..

select empno,ename,hiredate from emp1
where hiredate between
add_months(to_date('01-'|| upper('&Mon')||'-'||&yr,'DD-MON-
YYYY'),-2) and last_day(add_months(to_date('01-'|| upper
('&Mon')||'-'||&yr,'DD-MON-YYYY'),-1))

Answer / venkat

select *from emp where floor(months_between
(sysdate,hiredate))=2;

Answer / 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))

Answer / balaji s.t

select convert(varchar(10),
dateadd(dd,-(day(dateadd(mm,1,getdate()))-1), dateadd(mm,-2,getdate())), 120),

convert(varchar(10),dateadd(dd,-(day(getdate())),getdate()),120)

Answer / shanmukha srinivas

1)last two months joined employees
select * from emp where hiredate between add_months(trunc(sysdate,'month'),-2) and trunc(sysdate,'month')
2)last two months joined employees from today

select * from emp where hiredate between add_months(trunc(sysdate),-2) and trunc(sysdate)

Answer / satish

select * from emp where
round(months_between(sysdate,hire_date) in(1,2);

What is oracle and pl sql?

0 Answers  

What does trigger mean in psychology?

0 Answers  

What is sql indexing?

0 Answers  

Are views faster than queries?

0 Answers  

<<labele>> declare a=10 b=20, begin some statements declare a=30 c=40 end; what is the A value in nested block?

1 Answers   ITC Infotech,

which command using query analyzer will give you the version of sql server and operating system? : Sql dba

0 Answers  

write a query to delete similar records in same table

13 Answers   TCS,

What is the difference between sql and t sql?

0 Answers  

Is sqlexception checked or unchecked?

0 Answers  

What is the difference between clustered and non-clustered indexes?

0 Answers  

i hv 30 rows with date.ex:1month hav 4 weeks i want 1st day of the every week.write the qry for that.example jan has 4 weeks i need 1st dd for evry wk

1 Answers   Aspire,

What is the maximum number of triggers, you can apply on a single table?

0 Answers