adrianogand91 adrianogand91 - 2 months ago 6x
SQL Question

Find the value smaller neighbors

I have a table:

enter image description here

What is the query that allows me to take the next smallest value based on what I entered?


Use your input instead of myinput:

select max(value)
from mytable
where value < myinput