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 join 3 tables in sql?

0 Answers  

Advantages and disadvantages of stored procedure?

0 Answers  

What is fmtonly in sql?

0 Answers  

What is an Exception ? What are types of Exception ?

2 Answers  

what is meant by urlencode and urldocode? : Sql dba

0 Answers  

what is primary key? : Sql dba

0 Answers  

How can a function retun more than one value in oracle with proper example?

0 Answers  

What is memory optimized table?

0 Answers  

What does trigger mean in psychology?

0 Answers  

what is the command for user data type?

2 Answers  

Which function is used to return remainder in a division operator in sql?

0 Answers  

Is sql a scripting language?

0 Answers