title: How to fix “Only one expression can be specified in the select list when the subquery is not introduced with EXISTS” error?
body: <p>My query is as follows, and contains a subquery within it:</p>
  
  <pre><code>select a.bill_prvdr_acct_id, a.acct_id, a.bill_prvdr_acct_strt_dt, a.bill_prvdr_acct_end_dt
  from xxxx_snapshot.dbo.bill_prvdr_acct_history a
  where a.acct_id in 
  (select acct_id, count(*)
  from xxxx_snapshot.dbo.bill_prvdr_acct_history 
  group by acct_id
  having count(*) &gt; 1)
  </code></pre>
  
  <p>and i get the error message "Only one expression can be specified in the select list when the subquery is not introduced with EXISTS."</p>