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
- 50165 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / test
Join_date is the column in Emp table.
select * from emp
where join_date between sysdate and sysdate - 60
| Is This Answer Correct ? | 2 Yes | 11 No |
Post New Answer View All Answers
How much does sql cost?
How do I add a primary key to a table?
What is a primary key sql?
What is data modelling in sql?
how to drop an existing index in mysql? : Sql dba
How do you determine the current isolation level? : Transact sql
What is the difference among union, minus and intersect?
What is self-join and what is the requirement of self-join?
Which operator is used in query for pattern matching?
How to add a column ‘salary’ to a table employee_details?
How to connect a sql*plus session to an oracle server?
What are the different sql commands?
What are sql injection vulnerabilities?
What is the difference between cluster and non-cluster index?
Why do we use procedures in pl sql?
