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
- 50737 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
Can a key be both primary and foreign?
What is a heap in sql?
what is denormalization. : Sql dba
What is a clob in sql?
What is sql data?
What is sql trigger example?
What is rownum in sql?
What are tables and fields in the database?
What do you understand by pl/sql cursors?
Can 2 queries be executed simultaneously in a distributed database system?
How to use sql*plus built-in timers?
Show the cursor attributes of pl/sql.
how tsql statements can be written and submitted to the database engine? : Transact sql
Are stored procedures faster than dynamic sql?
How do you bind variables in pl sql?
