Skip to Content
0
Former Member
Jul 07, 2006 at 09:14 AM

Open SQL , Selecting Values Problem

102 Views

Hello,

I have a table like the following

Book ID Min Value

-


5705 10.00

5705 15.00

5705 22.00

5706 10.00

5706 50.00

If I have a value, such as 8.00, how can I use a single select to bring back just one record, in this case it would be the Minimum Value 10.00 only, ie it has to be less than or equal to the minimum value , and the lowest figure?

Thanks