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
- 50065 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / arijit
take Mon(like sep,oct,mar etc)
and year( like 2006,2007,1980 etc) as input...
and execute this query..
select empno,ename,hiredate from emp1
where hiredate between
add_months(to_date('01-'|| upper('&Mon')||'-'||&yr,'DD-MON-
YYYY'),-2) and last_day(add_months(to_date('01-'|| upper
('&Mon')||'-'||&yr,'DD-MON-YYYY'),-1))
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
Why is normalization important?
What is the maximum number of triggers, you can apply on a single table?
How do you modify a trigger?
Is pl sql still used?
What is the difference between a subquery and a join?
What is audit logout in sql profiler?
What is restrict in sql?
What are sql built in functions?
Which join condition can be specified using on clause?
how to start mysql server? : Sql dba
What is sql in oracle?
What is compiled query?
What is the difference between between and in condition operators?
Can you upgrade sql express to full sql?
Define concurrency control. : Transact sql
