1. Anuncie Aqui ! Entre em contato fdantas@4each.com.br

[SQL] Selecting number of rows at a sample rate over a time range in big query

Discussão em 'Outras Linguagens' iniciado por Stack, Outubro 31, 2024 às 13:02.

  1. Stack

    Stack Membro Participativo

    I have timestamp rows and I want to query over time interval [t1,t2] where t2-t1 can be few hours of span. I want to count the number of rows in this range but I want the output say where the rows are counted at 15 minutes interval. So if t2-t1 is 120 minutes, I expect 8 rows in output and the number of times rows occurred in the 15 minute windows.

    Not very clear on how to do that with Range functions

    Continue reading...

Compartilhe esta Página