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
- 49683 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
Can a composite key be null?
What is the difference between left outer join and left join?
How do I view stored procedures?
Can one improve the performance of sql*loader? : aql loader
What are the different dml commands in sql?
Explain the insert into statements in sql?
how many tables will create when we create table, what are they? : Sql dba
What is the use of <> sql?
Can I join the same table twice?
Explain how you can copy a file to file content and file to pl/sql table in advance pl/sql?
What is information schema in sql?
tell us something about heap tables. : Sql dba
What is the difference between the sql*loader and import utilities? : aql loader
What does pl sql developer do?
What are string functions in sql?
