adrianogand91 adrianogand91 - 4 months ago 7
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?

Answer

Use your input instead of myinput:

select max(value)
from mytable
where value < myinput
Comments