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.
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 serial sql?
What is the cause of mutating table error and how can we solve it?
What is cross join example?
Is sql considered coding?
what tools available for managing mysql server? : Sql dba
What is cursor explain with example?
What is the difference between rollback and rollback to statements?
how to check myisam tables for errors? : Sql dba
How do I truncate a word?
What is procedure explain with example?
Is time a data type in sql?
Give the order of sql select?
How to disable a trigger name update_salary?
What is the usage of nvl function?
tell us something about heap tables. : Sql dba