Partition by sql server

-- When using an aggregation function (SUM, COUNT, RANK, etc...)
-- Creates a specification on which you need to perform that agreggation
-- Example:
SELECT Customercity, 
       SUM(Orderamount) OVER(PARTITION BY Customercity) AS SumOrderAmount
-- performs avg amount when and only when you see a customer city
-- Orderamount | Customercity --(Comment added)-- | SumOrderAmount
-- 100	| Chicago "partition1" | 250
-- 150  | Chigago "partition1" | 250
-- 50   | Houston "partition2" | 75
-- 25   | Houston "partition2" | 75

Source: sqlshack.com

Similar codes

0 vote239 views1 answer
How to drop a column in mysql laravel stackoverflow
SQL
-2 votes188 views1 answer
Mysql see users and passwords
SQL
0 vote177 views1 answer
Reona
SQL
0 vote158 views1 answer
Check if a word appears at the end sql query
SQL
0 vote173 views1 answer
Mariadb mysql root access denied
SQL
0 vote230 views1 answer
Inner join distinct
SQL
3 votes213 views1 answer
Mysql cli connect with password
SQL
1 vote171 views2 answers
Sql server backup table
SQL
1 vote177 views2 answers
DROP TABLes regardless of constraints
SQL
1 vote187 views1 answer
Mysql get latest duplicate rows
SQL