DEV Community

Sebastiangperez
Sebastiangperez

Posted on

SQL Query Help

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)

Collapse
 
katnel20 profile image
Katie Nelson • 
SELECT name
FROM tableName
WHERE (max >= 35 && min <= 35)

Although the '35' should be declared as a variable.

Collapse
 
sebastiangperez profile image
Sebastiangperez •

Works... lapsus
Thanks Katie !!!

Collapse
 
katnel20 profile image
Katie Nelson •

Glad I could help Sebastian. Good luck with SQL.

Read next

arroxa profile image

Por que eu não me (re)coloco no mercado?

Vitor Rocha -

askyt profile image

How to Learn Machine Learning in 2024

Avnish -

danielsogl profile image

Diving Into Capacitor 6: What’s New, What’s Improved, and How to Upgrade

Daniel Sogl -

adolfont profile image

Erlang Workshop 2024 - Call for Papers

Adolfo Neto -