title: select count(*) from select
body: <p>I am trying to get row count from the following query. I get only row count as 1 but there are 35 records. Could you please let me know how to get the count from inner query?</p>
  
  <p>Thank you</p>
  
  <pre><code>SELECT COUNT(*)(SELECT DISTINCT a.my_id, a.last_name, a.first_name, b.temp_val
                  FROM Table_A a INNER JOIN Table_B b on a.a_id = b.a_id)
  </code></pre>