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
- 50050 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
I need a function for a train ticket reservation please answer it thanks in advance
How to return an array from java to pl/sql?
How can the performance of a trigger be improved?
What does (*) mean in sql?
How do I run a sql query in pgadmin 4?
Which language is used in sql?
What is the use of nvl function?
What is posting?
What is a sql statement?
What are the types of views in sql?
How we can create a table in pl/sql block. Insert records into it? Is it possible by some procedure or function? Please give example?
What is blind sql injection?
what are the t string functions available in tsql? : Transact sql
What is the primary use of normalization?
How can we make an if statement within a select statement?
