Im in one of those moments of lapsus where you think that im a fraud...
I have a table with this columns:
name , max , min
test, 100 , 40
test2, 39 , 20
and i have a result of 35 , and i need to know if is test or test 2 but the value must be between those max and min.
Does anyone knows a query to do that?
thanks.
Top comments (3)
Although the '35' should be declared as a variable.
Works... lapsus
Thanks Katie !!!
Glad I could help Sebastian. Good luck with SQL.