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 vote108 views1 answer
Sql server locks
SQL
2 votes110 views1 answer
SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost' (SQL: select * from information_schema.tables where table_schema = whatsapp and table_name = migrations and table_type = 'BASE TABLE')
SQL
-1 vote160 views2 answers
An error occurred while installing mysql2 (0.3.20), and Bundler cannot continue.
SQL
1 vote117 views1 answer
Postgres left join
SQL
0 vote95 views1 answer
Full syntax inner join
SQL
0 vote106 views1 answer
Traccar mysql
SQL
2 votes112 views2 answers
Postgresql search all tables for column name
SQL
3 votes93 views1 answer
Oracle revoke
SQL
0 vote106 views1 answer
Test the postgresql db connection
SQL
0 vote99 views1 answer
Postgresql create table default value timestamp
SQL