Nasar's Blog

Tag: sql

  • Qualify

    —

    by

    nasar
    in

    Snowflake QUALIFY function In a SELECT statement, the QUALIFY clause filters the results of window functions. QUALIFY does with window functions what HAVING does with aggregate functions and GROUP BY clauses. In the execution order of a query, QUALIFY is therefore evaluated after window functions are computed. QUALIFY <predicate> The QUALIFY clause simplifies queries that…

  • sql MODEL BY clause

    —

    by

    nasar
    in

    The MODEL clause enables you to create a multidimensional array by mapping the columns of a query into three groups: partitioning, dimension, and measure columns. These elements perform the following tasks: The MODEL clause enables you to specify rules to manipulate the measure values of the cells in the multi-dimensional array defined by partition and…

  • Importing Analytic View through BI Admin tool

    —

    by

    nasar
    in