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 vote197 views1 answer
Mysql url
SQL
8 votes186 views5 answers
Grant permission in postgres
SQL
11 votes181 views1 answer
Oracle insert into where
SQL
0 vote206 views1 answer
Create table with float datatype in sql server
SQL
0 vote199 views1 answer
Sqlplus change user
SQL
2 votes205 views2 answers
Mysql count rows returned
SQL
0 vote223 views1 answer
Search column name sql
SQL
4 votes205 views4 answers
Check constraint in ms sql
SQL
0 vote186 views1 answer
Truncate table sql server foreign key
SQL
0 vote209 views1 answer
Query to generate query to drop primary keys or foreign key in ms sql server
SQL