SQL window function

SQL

https://www.codewars.com/kata/589cf45835f99b2909000115/train/sql

SELECT 
  DATE(created_at) date,
  COUNT(created_at) count,
  SUM(COUNT(created_at)) OVER (ORDER BY DATE(created_at) ASC ) :: INTEGER total
FROM posts
GROUP BY date
ORDER BY date

/*window_function ( column )
OVER ( [ PARTITION BY partition_list ] [ ORDER BY order_list] )*/
changjulian17
Did you find this snippet useful?

Sign up for free to to add this to your code library

Getting the Last Record Using Rank Function - T-SQL Example
SQL

T-SQL

40
Getting the Date for the Previous Saturday with T-SQL
SQL

T-SQL

29
Remove Leading Zeros from a Field with T-SQL
SQL

T-SQL | Data Cleaning

8
left join LATERAL
SQL

6
SQL generate_series, dayofweek(DOW), weekday, functions
SQL

6
median
SQL

5
SQL RANK
SQL

5
SQL window function II: percent growth
SQL

5
EXISTS
SQL

4
SQL creating a view
SQL

4