title: Calculating a simple median on a column in MySQL
body: <p>I'm struggling to find the solution for a simple median problem. Given a table <code>my_table</code> with just one column:</p>
  <pre><code>my_column | 
  ----------|
  10        |
  20        |
  30        |
  40        |
  50        |
  60        |
  </code></pre>
  <p>How can I call a function to return the median of 35?</p>
  <p>I can't figure out how to make this syntax work when all I want is to return the median value:</p>
  <pre><code>SELECT
    PERCENTILE_CONT(0.5) WITHIN GROUP (ORDER BY my_column) OVER ( PARTITION BY my_column)
  FROM
    my_table
  </code></pre>