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

2 votes232 views2 answers
Spring where to put the data sql
SQL
0 vote617 views2 answers
Zsh: command not found: mysq
SQL
0 vote227 views1 answer
Mysql query to select the highest value
SQL
0 vote216 views1 answer
Sql server select ignore dupplicates
SQL
0 vote209 views1 answer
Show create table in postgresql
SQL
0 vote204 views1 answer
Mysql drop multiple tables at once
SQL
28 votes226 views6 answers
Mysql change user password
SQL
0 vote208 views4 answers
Best data type to represent money in mysql
SQL
0 vote214 views1 answer
Postgresql default value boolean
SQL
0 vote220 views2 answers
Get top 1 row of each group
SQL