title: Can you return the max value of a column multiple times in multiple rows in a MySQL SELECT statement?
body: <p>When I run the following statement:</p>
  
  <p>SELECT * FROM templates ORDER BY templateID</p>
  
  <p>I get the below:</p>
  
  <pre><code>+---------+-----------+-------------------+
  | Template| Name      | NumberOfColumns   |
  +---------+-----------+-------------------+
  |       1 |     blue  |                 1 |
  |       2 |     red   |                 2 |
  |       3 |     green |                 4 |
  +---------+-----------+-------------------+
  </code></pre>
  
  <p>And when I do the following:</p>
  
  <p>SELECT *, max(NumberOfContentBlocks) FROM templates;</p>
  
  <p>I get the below:</p>
  
  <pre><code>+---------+-----------+-------------------+
  | Template| Name      | NumberOfColumns   |
  +---------+-----------+-------------------+
  |       1 |     blue  |                 4 |
  +---------+-----------+-------------------+
  </code></pre>
  
  <p>Is there a SELECT statement that will return the below?:</p>
  
  <pre><code>+---------+-----------+-------------------+
  | Template| Name      | NumberOfColumns   |
  +---------+-----------+-------------------+
  |       1 |     blue  |                 4 |
  |       2 |     red   |                 4 |
  |       3 |     green |                 4 |
  +---------+-----------+-------------------+
  </code></pre>