pcsoft.us.windevCopyright 2026, PC SOFT17 Oct 2017 06:10:00 Z16 Oct 2017 14:31:00 ZHello, I have a table whose structure is: p_product_id p_weight p_rate This table contains following data: p_product_id p_weight p_rate 1 0.250 1 1 0.500 4 1 0.750 7 1 0.900 7.5 1 1.000 10 2 0.250 2 2 0.500 3 2 1.150 10.5 3 0.700 6.5 3 0.900 7.5 Now when a user enters Weight I need to find the rate applicable. So if user enters weight of 0.600 then based on the product selected the rate applicable is that of 0.750 that is 7 What query should I use for retrieving this rate? TIA30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62953-how-retrive-values-based-slabs/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62953-how-retrive-values-based-slabs-62968/read.awp17 Oct 2017 06:10:00 ZSascha, Quote Sascha77 if your logic needs to be the perfect match or take the next higher weight this query should do th…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62953-how-retrive-values-based-slabs-62968/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62953-how-retrive-values-based-slabs-62968/read.awpHow to retrive values based on Slabsguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62953-how-retrive-values-based-slabs-62955/read.awp16 Oct 2017 15:01:00 ZYogi, if your logic needs to be the perfect match or take the next higher weight this query should do the trick. select * …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62953-how-retrive-values-based-slabs-62955/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62953-how-retrive-values-based-slabs-62955/read.awpHow to retrive values based on Slabsguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62953-how-retrive-values-based-slabs-62954/read.awp16 Oct 2017 15:00:00 ZNot tested but try something like this: select s.p_rate from your_table s where s.p_product_id=the produtct you need and s.…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62953-how-retrive-values-based-slabs-62954/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62953-how-retrive-values-based-slabs-62954/read.awpHow to retrive values based on Slabs