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 vote301 views1 answer
Shows all databases created by user in ms sql
SQL
12 votes277 views4 answers
Mysql version query
SQL
0 vote274 views1 answer
How to connect sqlalchemy to mysql and deploy it
SQL
1 vote272 views1 answer
Oracle update with sequence
SQL
1 vote329 views1 answer
Sql select sum group by id laravel
SQL
0 vote293 views1 answer
How to find lowest in sql
SQL
14 votes300 views4 answers
Import database through command line
SQL
32 votes296 views6 answers
How to change column name in sql
SQL
1 vote307 views1 answer
Floor function in sql oracle
SQL
6 votes330 views2 answers
Install psql mac
SQL