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

1 vote188 views1 answer
Mysql sort by date column
SQL
0 vote190 views1 answer
Components/Fields of Internal Table
SQL
0 vote195 views1 answer
Geopoint from json mysql function
SQL
0 vote170 views1 answer
Couldn't execute 'SELECT COLUMN_NAME
SQL
2 votes187 views1 answer
Docker run postgres locally
SQL
2 votes207 views2 answers
Mysql count rows returned
SQL
0 vote188 views1 answer
Oracle sql date winter time
SQL
2 votes203 views1 answer
Sql OR
SQL
9 votes207 views3 answers
Mysql run sql file
SQL
0 vote201 views1 answer
Drop database using terminal postgres
SQL