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 / sdp
select * from emp
where trunc(months_between(sysdate, hiredate))=2;
Is This Answer Correct ? | 39 Yes | 14 No |
Post New Answer View All Answers
I need a function for a train ticket reservation please answer it thanks in advance
What is sqlite format?
what are the differences between procedure-oriented languages and object-oriented languages? : Sql dba
What is break?
Is stored procedure faster than query?
Do we need to rebuild index after truncate?
Which is the correct statement about truncate and delete?
What is the difference between stored procedure and view?
what is the difference between myisam static and myisam dynamic? : Sql dba
Why do we use subquery?
What is the use of function "module procedure" in pl/sql?
What does over partition by mean in sql?
Is sql a microsoft product?
What are literals in sql server?
What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql