DEV Community

Sebastiangperez

Posted on Dec 10, 2019

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)

Subscribe

Katie Nelson • Dec 10 '19

SELECT name
FROM tableName
WHERE (max >= 35 && min <= 35)

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

Sebastiangperez • Dec 10 '19

Works... lapsus
Thanks Katie !!!

Katie Nelson • Dec 10 '19

Glad I could help Sebastian. Good luck with SQL.

DEV Community

SQL Query Help

Top comments (3)

Read next

#10 Next.js 15 Serverless Route Handlers: A New Era for Full-Stack Development🧐😎

Hello everyone. I need some advice , I am looking for mentor to help go through coding journey to get first job. I am living un UK at the moment , moved back in three years to Poland. I have tried myself, and purchased Jonas JavaScript and React tutorials.

How Gamification in Web Development Can Supercharge User Experience

Unveiling the Magic of CSS Pseudo-Classes in Frontend Development