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
- 49680 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / satish
select * from emp where
round(months_between(sysdate,hire_date) in(1,2);
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Why self join is used in sql?
how can we destroy the cookie? : Sql dba
What is meant by cursor in sql?
Why we use sql profiler?
What are the three forms of normalization?
When to use inner join and left join?
what is the difference between inner and outer join? Explain with example. : Sql dba
Enlist the advantages of sql.
Is postgresql a nosql database?
What is the use of primary key?
what are the t string functions available in tsql? : Transact sql
Can you join views in sql?
What is the difference between nvl function, ifnull function, and isnull function?
What is 19 null in sql?
What is recursive stored procedure?
