title: PERCENTILE_CONT for median and rounding value to 4 decimal places
body: <p>I'm able to select median values using PERCENTILE_CONT, but I also want the values to only contain 4 decimal places.</p>
  
  <p>When I do this I get an error saying:</p>
  
  <blockquote>
    <p>'PERCENTILE_CONT' must have an OVER clause.</p>
  </blockquote>
  
  <p>This is my code:</p>
  
  <pre><code>SELECT 
      FIELD1,
      CAST(PERCENTILE_CONT(0.5) AS DECIMAL(10,4)) WITHIN GROUP (ORDER BY FIELD1) OVER (PARTITION BY FIELD1) AS Median
  FROM
      TABLE1
  </code></pre>
  
  <p>What am I doing wrong?</p>