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 vote150 views1 answer
How do i calculate someone's age based on a datetime type birthday?
SQL
0 vote307 views1 answer
Python get backup of sql
SQL
0 vote195 views1 answer
Sql select upcoming birthdays
SQL
8 votes275 views1 answer
Oracle search code in packages
SQL
9 votes194 views2 answers
Get first 3 letters in sql
SQL
0 vote183 views1 answer
Search In the Database using Text
SQL
31 votes233 views2 answers
Grant all priviledges to mysql user
SQL
5 votes230 views1 answer
Oracle add time to date
SQL
11 votes210 views2 answers
How to import mysql database command line
SQL
2 votes251 views2 answers
Mysql search for column name in all tables
SQL