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 vote255 views1 answer
Allow null in psql
SQL
0 vote239 views1 answer
Sql server on mac m1
SQL
1 vote247 views1 answer
How-can-i-start-postgresql-server-on-mac-os-x
SQL
-1 vote238 views5 answers
Online sql to linq generator
SQL
0 vote249 views1 answer
Alter table change default
SQL
0 vote233 views1 answer
Load data from text file to mysql database on mac terminal
SQL
40 votes232 views6 answers
Update table mysql
SQL
7 votes225 views3 answers
Postgre describe table
SQL
0 vote232 views1 answer
Sql select all records from all tables where not empty
SQL
0 vote225 views1 answer
What is mysql_pconnect
SQL