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
- 50184 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / suneel
select * from af where months_between(sysdate,hiredate)<=2
| Is This Answer Correct ? | 16 Yes | 2 No |
Post New Answer View All Answers
What is a constraint?
Can you inner join the same table?
Explain the advantages and disadvantages of stored procedure?
What are the syntax and use of the coalesce function?
What is java sql driver?
What are pl/sql cursor exceptions?
What is secondary key?
The select into statement is most often used to create backup copies of tables or for archiving records?
Which query operators in sql is used for pattern matching?
what is the difference between rownum pseudo column and row_number() function? : Sql dba
How much does a sql dba make? : SQL DBA
Why is there a need for sqlcode and sqlerrm variables?
Can we call stored procedure in function?
how can we take a backup of a mysql table and how can we restore it. ? : Sql dba
How do I tune a sql query?
