Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I want to use the sum(if)-function for a specific selection (all values between 3999 and 5000). My idea is like this, but it doesen't work:
sum(if(booking> 3999 and booking< 5000, cost)) as cost_special
Thank you for your help!
Thank you!
I use "group by", but if I comment it out it still didn't work.
I will take the solution provided by er.mohit.
Thank you very much for your help!