PeopleSoft Adoption Made Smooth & Simple!
On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool. Claim Your Free WalkMe Account Now
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.
|php hashing methods||3||49|
|PHP URL Parameter to simple URL for single folder||16||48|
|WordPress use get_posts() on list of IDs but keep distinct order of IDs in results returned||2||53|
|php problem trying to see the diffrence in logic between 2 pages||1||23|
Join the community of 500,000 technology professionals and ask your questions.