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
- 50083 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
What is difference between sql and mysql?
What is a primary key sql?
What are the events on which a database trigger can be based?
Is there a pl/sql pragma similar to deterministic, but for the scope of one single sql select?
How many sql core licenses do I need?
Why does sql need a server?
i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5
List different type of expressions with the example.
Explain clause in sql?
Show the cursor attributes of pl/sql.
what is a foreign key ? : Sql dba
Which constraints we can use while creating database in sql?
How does postgresql compare to mysql?
what is offset-fetch filter in tsql? : Transact sql
How do we accept inputs from user during runtime?
