Jump to content
scb

Value in a range

Recommended Posts

I have a table that contains ranges for each pair of columns id_indicator / id.
For example, for the pair id_indicator / id with value Ind1 / 1, if the percentage is 57%; I need to know that this percentage must correspond to the color "naranja" (column color_indicador).

What better solution could I implement, please?

Thank you very much in advance. Regards,

 

image.png.2424cada8e9cbdf671c8e9088cde1a62.png

Share this post


Link to post
Share on other sites

Hello SCB,

Write a SELECT query with ID and ID_INDICATOR in the WHERE condition and put the below condition.

"AND 57 between RANGO_MIN and RANGO_MAX"

Adding the above condition will return you the desired row.

 

Thank you,

Boobal Ganesan

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×