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
- 49704 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / pracheth
select * from temployees where to_char(hiredate,
'month') in
(to_char(trunc(sysdate,'month')-30,'month'),to_char(trunc(sysdate,'month')-60,'month'))
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What is vector point function?
Where is sql database stored?
What is the non-clustered index in sql?
How many types of indexes are there in sql?
What is the difference between sql, mysql and sql server?
What is sql profiling in oracle?
What is sql scripting?
Is null operator in sql?
What does varchar include?
Which language is used in sql?
what is the difference between mysql_fetch_array and mysql_fetch_object? : Sql dba
How many types of privileges are available in sql?
What are sql triggers used for?
what is the difference between truncate and drop statements? : Sql dba
how can we transpose a table using sql (changing rows to column or vice-versa) ? : Sql dba
