title: Selecting the most common value from relation - SQL statement
body: <p>I have a table within my database that has many records, some records share the same value for one of the columns. e.g.</p>
  
  <pre><code>|  id  |  name  |  software  |
  ______________________________
  |  1   |  john  |  photoshop |
  |  2   |  paul  |  photoshop |
  |  3   |  gary  |  textmate  |
  |  4   |  ade   |  fireworks |
  |  5   |  fred  |  textmate  |
  |  6   |  bob   |  photoshop |
  </code></pre>
  
  <p>I would like to return the value of the most common occurring piece of software, by using an SQL statement.</p>
  
  <p>So in the example above the required SQL statement would return 'photoshop' as it occurs more than any other piece of software.</p>
  
  <p>Is this possible?</p>
  
  <p>Thank you for your time.</p>