title: Filter maximum value from sql count query
body: <p>I currently have the following query</p>
  
  <pre><code>SELECT organisation.organisationID, COUNT(organisation.organisationID)
  FROM position, positionLocation, organisation
  WHERE position.positionLocationID = positionLocation.positionLocationID AND
  positionLocation.organisationID = organisation.organisationID AND
  position.status = 'Open'
  GROUP BY organisation.organisationID;
  </code></pre>
  
  <p>This query outputs</p>
  
  <pre><code>organisationID | countOrganisationID
  1                3
  3                2
  5                3
  </code></pre>
  
  <p>I would like to display records that have max countOrganisationID. Ideally i would just like output the organisationID with its corresponding organisationName if possible.</p>
  
  <p>Something along the lines of</p>
  
  <pre><code>organisationID | organisatioName
  1                name1
  5                name2
  </code></pre>
  
  <p>Any help would be appreciate</p>
  
  <p>Thanks</p>