15 Replies Latest reply: Jan 24, 2017 6:13 PM by Michael Andrews RSS

    Equivalent to Variance Function?

    Michael Andrews

      I'm wondering if there is some sort of equivalent to the variance sql function? I.e., a way for me to get 1.66 from this data as you would if you ran this sql

       

      CREATE TABLE #foo(f_val int)

       

      INSERT INTO #foo VALUES(1), (2), (3), (4)

       

      SELECT var(f_val) FROM #foo