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

[SQL] How to use PERCENTILE_CONT without over clause? any alternative to it?

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

  1. Stack

    Stack Membro Participativo

    I am interested in finding median of an entire column in SQL Server and I don't want to partition/subset column based on some other attribute. I am looking for a way to use PERCENTILE_CONT without over or any other function to find median. I have tried

    over(my_table)
    OVER (PARTITION BY NULL)
    OVER ( NULL)

    Continue reading...

Compartilhe esta Página