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 vote124 views2 answers
Mysql regexp match word
SQL
1 vote132 views1 answer
Psql autocomplete for mac brew install
SQL
4 votes121 views1 answer
Search column by name mysql
SQL
0 vote153 views1 answer
Authentication modes in sql server
SQL
0 vote144 views1 answer
Original Query
SQL
2 votes143 views5 answers
Eloquest how to select one specific column in database
SQL
2 votes203 views1 answer
Mysql create user with remote access
SQL
0 vote131 views1 answer
Database xml sql
SQL
9 votes133 views3 answers
Oracle undo usage by session
SQL
0 vote141 views1 answer
Sql select where more than one record exists
SQL