title: SQL Server group
body: <p>I have a sql server database table with columns as shown below :
  <a href="https://i.stack.imgur.com/gz0Hg.jpg" rel="nofollow noreferrer">enter image description here</a></p>
  <p>I want to get an output something like this :<a href="https://i.stack.imgur.com/4bUnU.jpg" rel="nofollow noreferrer">enter image description here</a></p>
  <p>I cannot figure out how I can group only zeros listed for EPID and group only ones in my query ? Can anyone point me out how I can solve this ?</p>