Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 15 Answers
- 49657 Views
- Wipro, I also Faced
- E-Mail Answers
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
Is sql a programming?
How many parts of a pl sql block are optional?
Why do you partition data?
What is time based sql injection?
What are the two different parts of the pl/sql packages?
What is the requirement of self-join?
Does mysql_real_escape_string prevent sql injection?
What is data definition language?
How do I run a sql trace?
What is a database event trigger?
Write a sql select query that only returns each name only once from a table?
How do you take the union of two tables in sql?
Write the alter statement to enable all the triggers on the t.students table.
Why we use sql profiler?
What is sql server and ase?
