Strange result of analytic aggregate (min/avg/max) using order by
Hello
I have a hard time understanding the results of the query below. It uses the classic scott.emp table.
The result of the min function with a partition by and an order by are strange. The other two analytic calculated columns make perfect sense. I would think adding a (redundant) order by to the column aliased Min_sal2 should not change the result of the min-function. But it does. I know, the order by is not needed for min (or max or avg), but I would not expect it to ruin the result. Can anyone explain?
I am on 12.2.0.1, not that I think this has anything to do with it.