Answer / pracheth

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

Answer / venu

select * FROM(SELECT ENAME, Abs(to_date('&DATE' ,'dd/mm/yy')- HIREDATE) AS DATES FRom EMP) where dates<60;

Answer / subbu

Assuming that the Table name is "Employee" & his/her date of
joining is stored in column "JoiningDate". Below query gives
you the result


If (Month(GetDate()))=1
Select * from Employee Where (Month(JoiningDate)) in (11,12)
And Year(JoiningDate)=Year(GetDate()-1)
Else if Month(GetDate())=2
Select * from Employee Where (Month(JoiningDate)=12 And
Year(JoiningDate)=Year(GetDate()-1)) or
(Month(JoiningDate)=1 And Year(JoiningDate)=Year(GetDate()))
Else
Select * from Employee Where
Year(JoiningDate)=Year(GetDate())And
Month(JoiningDate)>=Month(GetDate()-2) And
Month(JoiningDate)<=Month(GetDate()-1)

Answer / xyz

select * from emp where add_months(sysdate ,-2);

Answer / test

Join_date is the column in Emp table.

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

Can we rename a column in the output of sql query?

0 Answers  

How packaged procedures and functions are called from the following?

2 Answers  

What is normalisation in sql?

0 Answers  

four procedures is are there should i write their in a package

2 Answers  

What is the sql case statement?

0 Answers  

1. what is the exact use of hint in sql. 2. How we can avoid index scan in sql even though index is there in the table.

1 Answers   Polaris,

what is the cursor and use of cursor in pl/sql ?

4 Answers  

What is a schema sql?

0 Answers  

what is 'trigger' in sql? : Sql dba

0 Answers  

Which sorts rows in sql?

0 Answers  

Does postgresql run on the cloud?

0 Answers  

What is meant by Join? What are the different types of Joins available? Explain.

5 Answers   Cap Gemini,