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 vote191 views1 answer
Date datatype in livesql
SQL
0 vote189 views1 answer
Mysql zerofill
SQL
20 votes176 views5 answers
Reset auto increment mysql
SQL
0 vote171 views1 answer
Login phpmyadmin without password
SQL
0 vote180 views1 answer
Mysql select inside sum
SQL
0 vote179 views1 answer
How to add more columns to a table in mysql
SQL
1 vote190 views1 answer
Psql lst trigger
SQL
13 votes214 views3 answers
Mysqldump structure only
SQL
1 vote307 views3 answers
Uninstall postgresql mac
SQL
0 vote187 views1 answer
Reset keys in sql
SQL