Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
And, the query I tried as
column1,column2,column3,column4 p1,wip,100,user1 p2,wip,100,user2 p3,wip,100,user3
This query, returns the result as required. However, if I change column2='unbilled' then also it returns the same results.
SELECT sum(column3) AS total FROM table1 WHERE column2='wip' and column4='user1' OR column4='user2' OR column4='user3'
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.