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 vote297 views1 answer
Ms sql - add one hour to time
SQL
1 vote417 views1 answer
T-sql disable system versioning
SQL
3 votes420 views2 answers
Savepoint in sql
SQL
0 vote349 views1 answer
An error occurred while installing mysql2 (0.5.3)
SQL
2 votes375 views3 answers
Sql truncate table
SQL
0 vote353 views1 answer
Month mysql
SQL
0 vote372 views1 answer
Display all node label neo4j
SQL
0 vote351 views1 answer
Sql offfset
SQL
6 votes360 views2 answers
Clear a table in mysql
SQL
5 votes369 views1 answer
Minecraft java port number
SQL