Skip to main content

Breadcrumb

  1. insights

Windowing Function With Aggregate Function

  • Google BigQuery
February 23, 2015
By Bounteous
SELECT
  num,
  MAX(num) OVER (ROWS BETWEEN CURRENT ROW AND 1 FOLLOWING) as max_here_1_following
FROM 
  ( SELECT 2 AS num),
  ( SELECT 4 AS num),
  ( SELECT 3 AS num),
  ( SELECT 1 AS num),

 

Related Perspectives

Nov 17 · Google Marketing Platform

An Introduction to Google Ads Data Hub

Nov 4 · Google BigQuery

Bounce Rate by Landing Page

 
Jun 26 · Google BigQuery

Days Since Last Session with Window Functions