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
- 50074 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / suneel
select * from af where months_between(sysdate,hiredate)<=2
| Is This Answer Correct ? | 16 Yes | 2 No |
Post New Answer View All Answers
Is ms sql is free?
What is the most restrictive isolation level? : Transact sql
How much ram can sql express use?
How do you take the union of two tables in sql?
How do you copy a table in sql?
Explain what is table in a database?
Define tables and fields in a database
How do I run a sql script?
write an sql query to find names of employee start with 'a'? : Sql dba
What is procedure and function?
What is primary key and unique key?
what is the use of double ampersand (&&) in sql queries?
What are the advantages of pl sql over sql?
Does a user_objects view have an entry for a trigger?
What is graph sql?
