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
- 49656 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / avi007
select * from employee where (sysdate-hiredate) <=60
| Is This Answer Correct ? | 6 Yes | 3 No |
Post New Answer View All Answers
Give the order of sql select?
What are character functions?
What is a sql schema used for?
Why use triggers in sql?
What is pl sql and why it is used for?
What is difference between inner join and self join?
What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql
Whis is not false in primary key?
How bulk collect improves performance?
How many columns should be in an index?
What does where 1/2 mean in sql?
explain the advantages and disadvantages of stored procedure? : Sql dba
how many tables will create when we create table, what are they? : Sql dba
How can I speed up sql query?
Sql technical questions
