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
how to start mysql server? : Sql dba
How to combine two stored procedures in sql?
Explain what is a subquery ?
What is embedded sql with example?
Can we use join in subquery?
What is the use of sql trace?
What is write ahead logging in sql server?
Explain aggregate functions are available there in sql?
How sql query is executed?
GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?
What is the difference between join and natural join?
Is nosql relational?
Is sql low level language?
How to know the last executed procedure?
Why is there a need for sqlcode and sqlerrm variables?