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 vote386 views1 answer
Connect google bigquery connect using sqirrel
SQL
0 vote276 views1 answer
Mysql convert column to uppercase
SQL
2 votes308 views1 answer
Get first 3 letters name in sql
SQL
8 votes362 views3 answers
SQL column name
SQL
0 vote320 views2 answers
Oracle create chain rule
SQL
-1 vote332 views1 answer
Module operator in oracle sql
SQL
1 vote346 views1 answer
Update from table tsql
SQL
0 vote338 views1 answer
How to start my sql server on mac
SQL
0 vote354 views1 answer
Google sheets data validation custom formula filter
SQL
0 vote318 views1 answer
How to use query in nosql
SQL