title: How to use count function in the below mentioned query?
body: <p>I just want to know how to add count function in the below mentioned query in which I only have to display those records where count of p_id should equal to 1</p>
  
  <pre><code>select Distinct p_id,i.img_path as ImagesName, 
  (
    select p.project_details from [Project] p where p.p_id=i.p_id
  ) as ProjectName
  from [p_Image] i
  </code></pre>