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

4 votes169 views3 answers
Order by value mysql
SQL
2 votes214 views2 answers
Sql query to list all tables in a database sql server
SQL
1 vote167 views1 answer
Postgresql export output table as a csv
SQL
0 vote185 views1 answer
The report definition has an invalid target namespace 'http://schemas.microsoft.com/SQLServer/reporting/reportdesigner'
SQL
4 votes197 views1 answer
An error occurred while installing pg (1.2.3), and Bundler cannot continue. Make sure that `gem install pg -v '1.2.3' --source 'https://rubygems.org/'` succeeds before bundling.
SQL
2 votes231 views1 answer
Oracle trace session
SQL
0 vote238 views1 answer
Insert query return id mysql
SQL
0 vote178 views1 answer
Get employees if not contains in sql
SQL
0 vote198 views1 answer
Wincc 7.4 to sql stackoverflow
SQL
3 votes207 views1 answer
Oracle cannot access v$session
SQL