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.
Answer Posted / 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)
Is This Answer Correct ? | 0 Yes | 4 No |
Post New Answer View All Answers
What is set serveroutput on in pl sql?
What is varchar data type in sql?
How do you write an index?
What is type and rowtype in pl sql?
What is schema in sql example?
what is blob? : Sql dba
How can you know that statistics should be updated?
tell me about various levels of constraint. : Sql dba
What is sql*plus?
Are stored procedures faster than queries?
what is 'trigger' in sql? : Sql dba
Does sql require a server?
What is the purpose of using pl/sql?
How do I run sql?
How to write a single statement that concatenates the words ?hello? And ?world? And assign it in a variable named greeting?