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.
Answer Posted / venkat
select *from emp where floor(months_between
(sysdate,hiredate))=2;
Is This Answer Correct ? | 6 Yes | 5 No |
Post New Answer View All Answers
how to enter numeric values as hex numbers? : Sql dba
What is java sql drivermanager?
What is difference between stored procedures and application procedures?
how can we submit a form without a submit button? : Sql dba
What are schema-level triggers?
what is rdbms? : Sql dba
What is difference between hql and sql?
what is the syntax for using sql_variant_property? : Transact sql
What is the use of desc in sql?
What is a subquery in sql?
list out some tools through which we can draw e-r diagrams for mysql. : Sql dba
What is use of package in pl sql?
What is a natural join?
Define the select into statement.
Can we commit inside a trigger?