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 vote272 views1 answer
Sql server port 1434
SQL
-3 votes356 views8 answers
Sql to c# linq converter online
SQL
0 vote295 views1 answer
Get clob size oracle
SQL
4 votes300 views1 answer
Sql delete multiple conditions
SQL
0 vote271 views1 answer
How to connect pgadmin with excel
SQL
3 votes313 views1 answer
Oracle undo tablespace schema
SQL
1 vote255 views1 answer
Create sample data postgresql
SQL
0 vote272 views1 answer
Capture Image Store Image in Folder and image Path in sqlite Database
SQL
5 votes278 views3 answers
Oracle first day of last year
SQL
0 vote222 views1 answer
Ms sql print more than 1 variable
SQL