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 vote218 views2 answers
Clauses in mysql
SQL
1 vote178 views1 answer
User privileges postgresql information_schema
SQL
0 vote158 views1 answer
Finish transaction sql
SQL
0 vote187 views1 answer
Mysql_union
SQL
0 vote192 views1 answer
Configure: error: Cannot find libpq-fe.h. Please specify correct PostgreSQL installation path
SQL
0 vote178 views1 answer
Postgresql parse json array
SQL
0 vote194 views1 answer
Sql python hwo to pass a list in paramerter
SQL
0 vote211 views1 answer
How to add unique key constraint in mysql
SQL
2 votes149 views1 answer
Latest record in sql
SQL
0 vote205 views1 answer
EnvironmentError: mysql_config not found
SQL