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
- 50749 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / venu
select * FROM(SELECT ENAME, Abs(to_date('&DATE' ,'dd/mm/yy')- HIREDATE) AS DATES FRom EMP) where dates<60;
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
How is sql used in oracle?
What is the difference between cluster and non-cluster index?
What does rownum mean in sql?
What is scalar function?
What are different types of triggers?
What is java sql driver?
How many types of privileges are available in sql?
Why indexing is needed?
what are the differences between char and nchar? : Sql dba
Write a sql select query that only returns each name only once from a table?
How to fix oracle error ora-00942: table or view does not exist
What does stand for in sql?
Which join condition can be specified using on clause?
How to write a single statement that concatenates the words ?hello? And ?world? And assign it in a variable named greeting?
What does count (*) mean?
