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
- 50762 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / avi007
select * from employee where (sysdate-hiredate) <=60
| Is This Answer Correct ? | 6 Yes | 3 No |
Post New Answer View All Answers
What is oracle sql called?
how to run 'mysql' commands from a batch file? : Sql dba
what is a constraint? : Sql dba
explain primary keys and auto increment fields in mysql : sql dba
how can we transpose a table using sql (changing rows to column or vice-versa) ? : Sql dba
explain advantages of innodb over myisam. : Sql dba
Can we perform dml on view?
What is difference between sql and mysql?
Is crud a cuss word?
How to display Row Number with Records in Oracle SQL Plus?
What action do you have to perform before retrieving data from the next result set of a stored procedure ?
What are the operators in sql?
Is it possible to remove child records without removing master table records...the two having pk,fk relationship?
What is data modelling in sql?
What is trigger price?
