SQL Query for taking about values thru column comparison

Question

Hi I need help regarding a sql query.
I have a table named paystructure with fields as minSale, maxSale, empCategory, incentiveAmt, qtySold
When i enter quantity sold then i should get the incentiveAmt based on the minSale and maxSale and empCategory.
This can be interpreted as :--
minSale    maxSale   incentiveAmt
100         200              50
201         300              100
301         400              150
How can i get this value based on qtySold.
I need this urgent help
Please guide me for this query
Thanks in advance.

Jignesh Trivedi · Answer

hi,
you can use Case when in this case... example..
declare @itemsold int =201
select
case when @itemsold between 100 and 200 then 50
when @itemsold between 201 and 300 then 100
when @itemsold between 301 and 400 then 150 end hope this will help you.