SQL Language (MOSC)

MOSC Banner

Different Result between Pivot and Non-Pivot Queries

edited Aug 27, 2015 3:59PM in SQL Language (MOSC) 2 commentsAnswered ✓

I have two queries, one is a pivot query and the other is the same query but does not perform the pivot.  The pivot query provides the data table for a report and the non pivot query provides the data for a graph. In the pivot query the aggregate function is performed in the pivot section and in the non pivot query the aggregate function is performed in the select statement.  My problem is that the result does not match in one column between the two queries.  Can anyone tell my why?  If I change the pivot query to perform

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