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 vote253 views1 answer
How refresh navicat tables to see new tables
SQL
1 vote259 views1 answer
How to drop function in sql
SQL
0 vote296 views1 answer
Mysql Puede ser solamente un campo automatico y este debe ser definido como una clave
SQL
0 vote254 views2 answers
Sql update top 100
SQL
0 vote256 views1 answer
Get time component of datetime sql
SQL
0 vote247 views1 answer
MySQL error code 2068
SQL
2 votes260 views2 answers
Change mysql password from command line
SQL
1 vote254 views1 answer
Get url of cpanel database hostname
SQL
3 votes292 views3 answers
Raw select laravel
SQL
1 vote266 views1 answer
Adding a check statement in sql
SQL