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

9 votes162 views2 answers
Sql limit to 5 results
SQL
3 votes145 views1 answer
Two select sql
SQL
14 votes145 views4 answers
Remove record from table sql
SQL
1 vote160 views1 answer
Sqlstate[imssp]: the active result for the query contains no fields.
SQL
0 vote150 views1 answer
Rename constraint postgresql
SQL
16 votes170 views3 answers
Get count of duplicate records
SQL
0 vote161 views1 answer
Error: com.mysql.cj.jdbc.Driver not loaded. Are you sure you've included the correct jdbc driver in :jdbc_driver_library?
SQL
0 vote157 views1 answer
Shows all databases created by user in ms sql
SQL
0 vote152 views1 answer
Mysql return column names when table is empty
SQL
12 votes149 views4 answers
Mysql version query
SQL