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
- 50750 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
What is a database event trigger?
What is the difference between row level and statement level trigger?
What is data profiling in sql?
How to select the Nth maximum salary from Table Emp in Oracle SQL Plus ?
Do triggers have restrictions on the usage of large datatypes, such as long and long raw?
Can we call dml statement in function?
Why is normalization important?
How to get help at the sql prompt?
What is the purpose of design view?
What is an invalid partition table?
write an sql query to find names of employee start with 'a'? : Sql dba
How do you use a while loop in pl sql?
What is a Mapplet?
what is data manipulation language? : Sql dba
Mention what does plv msg allows you to do?
