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
- 49703 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
What kind of join is join?
Is inner join same as self join?
Explain alias in sql?
What are the different types of sql commands?
how to get a list of all tables in a database? : Sql dba
Can 2 queries be executed simultaneously in a distributed database system?
What is a column in a table?
How do you drop a trigger?
Differentiate between syntax and runtime errors.
Does mysql_real_escape_string prevent sql injection?
Why should I use postgresql?
What is the purpose of cursors in pl/sql?
how to shut down the server with 'mysqladmin'? : Sql dba
Explain constraints in sql?
How to write pl sql program in mysql command prompt?
