Combined use ORDER BY and PARTITION BY clauses together in Oracle SQL

preview_player
Показать описание
In this video tutorial we will learn piecing the ORDER BY and PARTITION BY clauses in Oracle SQL
Рекомендации по теме
Комментарии
Автор

Sir, If you dont mind can you please clarify my doubt. Please!

From the query which you have written : Sum(Salary) over(partition by Department_id order by employee_id).

How does this query work. Which will be executed first.

Is the data inside the over clause partitioned and then based on that data Sum(Salary) is calculated.

(or)

Is sum(salary) will be calculated 1st and then the data inside over clause will be partitioned!

siddharthapenchala