| Re: How to get the missing information from a table? [message #371635] |
Fri, 17 November 2000 05:31 |
Tittom
Messages: 15
Registered: November 2000
|
Junior Member |
|
|
Here is the table I created :
create table TBNGRADE
(
GRADE NUMBER,
VAL1 NUMBER,
VAL2 NUMBER
)
Here is the data I inserted :
GRADE VAL1 VAL2
1 1 1000 2000
2 2 2001 3000
3 3 3001 4000
4 4 4001 5000
5 5 5001 6000
6 6 6001 7000
And here is a query which gives me the grade for a salary of 4500 :
select grade from tbngrade where val1<=4500 and val2>=4500
I hope this will help you...
Tittom.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
