PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

Help to add a having clause to PS Query

edited Jun 3, 2016 4:41PM in PeopleTools and Lifecycle Management - PSFT (MOSC) 2 commentsAnswered ✓

Hi, Can someone help on how to implement below having clause in PS Query? sum(field3)+sum(field4) not equal to sum(field3+field4). Thanks.

select field1, field2, sum(field3), sum(field4)

from table1

group by field1, field2

having (sum(field3)+sum(field4)) <>0

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center