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
- 50177 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
how is exception handling handled in mysql? : Sql dba
What is the best free sql database?
What are transaction and its controls?
What is cursor in pl sql?
write an sql query to find names of employee start with 'a'? : Sql dba
How can I tell if sql is running?
What does desc stand for?
How many types of tables are there?
how to run 'mysql' commands from a batch file? : Sql dba
Is pl sql better than sql?
how to use myisamchk to check or repair myisam tables? : Sql dba
What are dml commands?
What is sharding in sql?
What does where 1 1 mean in sql?
Which command is used to delete a trigger?
