| sql query [message #373268] |
Sat, 07 April 2001 08:37  |
Ameen
Messages: 2
Registered: April 2001
|
Junior Member |
|
|
Friends as i am new to oracle i have job in hand and i need you help in this. from one table how i query records based on three diffrent conditions and fetch records between two diffrent dates (from - to)
thanks
Ameen.
|
|
|
|
| Re: sql query [message #373270 is a reply to message #373268] |
Sun, 08 April 2001 20:08  |
Naresh Sharma
Messages: 12
Registered: April 2001
|
Junior Member |
|
|
Try this :
select * from emp
where deptno = 10
and job = 'MANAGER'
and hiredate between sysdate and sysdate-3;
----------------------
HTH
Naresh
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
