Consider an SQL query that has a Window function with an ORDER BY inside the OVER clause, and an ORDER BY in the main query like this:

SELECT product$\_$id$,$ sale$\_$date, amount$\_$sold, SUM$($amount$\_$sold$)$ OVER $($PARTITION BY product$\_$id ORDER BY sale$\_$date$)$ AS total$\_$sales

FROM sales

ORDER BY product$\_$id$,$ sale$\_$date;

Consider an SQL query that has a Window function with an ORDER BY inside the OVER clause, and an ORDER BY in the main query like this:

SELECT product$\_$id$,$ sale$\_$date, amount$\_$sold, SUM$($amount$\_$sold$)$ OVER $($PARTITION BY product$\_$id ORDER BY sale$\_$date$)$ AS total$\_$sales

FROM sales

ORDER BY product$\_$id$,$ sale$\_$date;

The query will be illegal

The main ORDER BY will be executed first

The ORDER BY inside the OVER clause will be executed first

None of the above