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
- 50744 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 'mysqld'? : Sql dba
How to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?
What does an inner join do?
what is the difference between primary key and unique key? : Sql dba
Why left join is used in sql?
Can %notfound return null after a fetch?
How do you declare a variable in pl sql?
Can we use the cursor's to create the collection in PL/SQL?
Is sql sequential or random?
What are types of indexes in sql?
Is primary key is clustered index?
What is rank function in sql?
What is pragma in sql?
What is Difference Between Unique and Primary Key Constraints?
What are triggers in sql?
