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 vote331 views1 answer
Mysql find missing values
SQL
0 vote337 views3 answers
Sql drop all tables
SQL
0 vote330 views1 answer
Addition of 2 column value in mysql
SQL
0 vote398 views1 answer
How to add auto increment primary key
SQL
20 votes333 views3 answers
SQL query rename table
SQL
0 vote320 views1 answer
How to get all values in a table mysql in c#
SQL
1 vote346 views3 answers
Rows, INSERT INTO
SQL
0 vote328 views1 answer
Get foreign table names mysql
SQL
1 vote435 views1 answer
Aqua Data studio postgresql ssl
SQL
2 votes332 views1 answer
SQL column name Postgre
SQL