title: Using COUNT and Return Percentage Against SUM of Records
body: <p>Pretty simple question I suppose, but I can't find the answer on here!</p>
  
  <p>I am trying to calculate the volume of records based on a WHERE clause, as well as return a percentage of those records based on the same where clause. The percentage would be calculated against the total amount of records in the database. For example, I count all my records that meet "MyCondition":</p>
  
  <pre><code>SELECT COUNT(*) FROM [MyTable]     
  WHERE Condition='MyCondition'
  </code></pre>
  
  <p>This works fine. However, how does one take that count, and return the percentage it equates to when put against all the records in the database? In other words, I want to see the percentage of how many records meet WHERE Condition='MyCondition' in regards to the total record count.</p>
  
  <p>Sorry for the simple question and TIA! I am using MS SQL 2012.</p>