Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

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

Answers were Sorted based on User's Feedback



I want to display the employees who have joined in last two months. (It should be executed randomly..

Answer / sdp

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

Is This Answer Correct ?    39 Yes 14 No

I want to display the employees who have joined in last two months. (It should be executed randomly..

Answer / suneel

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

Is This Answer Correct ?    16 Yes 2 No

I want to display the employees who have joined in last two months. (It should be executed randomly..

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 %

Is This Answer Correct ?    14 Yes 1 No

I want to display the employees who have joined in last two months. (It should be executed randomly..

Answer / avi007

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

Is This Answer Correct ?    6 Yes 3 No

I want to display the employees who have joined in last two months. (It should be executed randomly..

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

Is This Answer Correct ?    3 Yes 1 No

I want to display the employees who have joined in last two months. (It should be executed randomly..

Answer / venkat

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

Is This Answer Correct ?    6 Yes 5 No

I want to display the employees who have joined in last two months. (It should be executed randomly..

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

Is This Answer Correct ?    1 Yes 0 No

I want to display the employees who have joined in last two months. (It should be executed randomly..

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)

Is This Answer Correct ?    1 Yes 1 No

I want to display the employees who have joined in last two months. (It should be executed randomly..

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)

Is This Answer Correct ?    0 Yes 0 No

I want to display the employees who have joined in last two months. (It should be executed randomly..

Answer / satish

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

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More SQL PLSQL Interview Questions

How to order siblings in oracle hierarchy queries?

0 Answers  

What is oracle pl sql developer?

0 Answers  

What is sql mysql pl sql oracle?

0 Answers  

what are the advantages of mysql in comparison to oracle? : Sql dba

0 Answers  

What is data definition language?

0 Answers  

Enlist the characteristics of pl/sql?

0 Answers  

How do I save a sql query?

0 Answers  

What is sql and explain its components?

0 Answers  

Explain uses of cursor.

1 Answers  

What are literals in sql server?

0 Answers  

Is sql better than access?

0 Answers  

What is not in sql?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories